SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002096s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047402s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606443 LIMIT 5 [ RunTime:0.018707s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.017046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606443 ORDER BY `minOrder` ASC [ RunTime:0.019587s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606443 ORDER BY `unit` DESC [ RunTime:0.000894s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606443 LIMIT 2 [ RunTime:0.008121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606443 ORDER BY `minOrder` ASC [ RunTime:0.020513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17312008 LIMIT 5 [ RunTime:0.043085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312008 ORDER BY `minOrder` ASC [ RunTime:0.025402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17312008 ORDER BY `unit` DESC [ RunTime:0.046732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17312008 LIMIT 2 [ RunTime:0.023176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312008 ORDER BY `minOrder` ASC [ RunTime:0.032427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605156 LIMIT 5 [ RunTime:0.038409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605156 ORDER BY `minOrder` ASC [ RunTime:0.043011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605156 ORDER BY `unit` DESC [ RunTime:0.032812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605156 LIMIT 2 [ RunTime:0.021675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605156 ORDER BY `minOrder` ASC [ RunTime:0.051331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661996 LIMIT 5 [ RunTime:0.049637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661996 ORDER BY `minOrder` ASC [ RunTime:0.033222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661996 ORDER BY `unit` DESC [ RunTime:0.044031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661996 LIMIT 2 [ RunTime:0.023290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661996 ORDER BY `minOrder` ASC [ RunTime:0.041014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605143 LIMIT 5 [ RunTime:0.035722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605143 ORDER BY `minOrder` ASC [ RunTime:0.014880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605143 ORDER BY `unit` DESC [ RunTime:0.015399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605143 LIMIT 2 [ RunTime:0.011767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605143 ORDER BY `minOrder` ASC [ RunTime:0.017329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606506 LIMIT 5 [ RunTime:0.010976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606506 ORDER BY `minOrder` ASC [ RunTime:0.009195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606506 ORDER BY `unit` DESC [ RunTime:0.013791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606506 LIMIT 2 [ RunTime:0.023743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606506 ORDER BY `minOrder` ASC [ RunTime:0.001556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605239 LIMIT 5 [ RunTime:0.019073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605239 ORDER BY `minOrder` ASC [ RunTime:0.001005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605239 ORDER BY `unit` DESC [ RunTime:0.020392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605239 LIMIT 2 [ RunTime:0.004778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605239 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15453417 LIMIT 5 [ RunTime:0.003695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453417 ORDER BY `minOrder` ASC [ RunTime:0.004861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15453417 ORDER BY `unit` DESC [ RunTime:0.000737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15453417 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453417 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148409 LIMIT 5 [ RunTime:0.005748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148409 ORDER BY `minOrder` ASC [ RunTime:0.021578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148409 ORDER BY `unit` DESC [ RunTime:0.003844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148409 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148409 ORDER BY `minOrder` ASC [ RunTime:0.001552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19625570 LIMIT 5 [ RunTime:0.001421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19625570 ORDER BY `minOrder` ASC [ RunTime:0.002099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19625570 ORDER BY `unit` DESC [ RunTime:0.009845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19625570 LIMIT 2 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19625570 ORDER BY `minOrder` ASC [ RunTime:0.000838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641357 LIMIT 5 [ RunTime:0.004094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19641357 ORDER BY `minOrder` ASC [ RunTime:0.005390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19641357 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19641357 LIMIT 2 [ RunTime:0.003375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19641357 ORDER BY `minOrder` ASC [ RunTime:0.014174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606232 LIMIT 5 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606232 ORDER BY `minOrder` ASC [ RunTime:0.002578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606232 ORDER BY `unit` DESC [ RunTime:0.006836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606232 LIMIT 2 [ RunTime:0.011438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606232 ORDER BY `minOrder` ASC [ RunTime:0.010214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662699 LIMIT 5 [ RunTime:0.004036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662699 ORDER BY `minOrder` ASC [ RunTime:0.002490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19662699 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19662699 LIMIT 2 [ RunTime:0.008267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19662699 ORDER BY `minOrder` ASC [ RunTime:0.008008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451391 LIMIT 5 [ RunTime:0.002152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451391 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451391 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451391 LIMIT 2 [ RunTime:0.003152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451391 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11337051 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11337051 ORDER BY `minOrder` ASC [ RunTime:0.007116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11337051 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11337051 LIMIT 2 [ RunTime:0.003367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11337051 ORDER BY `minOrder` ASC [ RunTime:0.003168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19653001 LIMIT 5 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653001 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19653001 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19653001 LIMIT 2 [ RunTime:0.009760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653001 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650651 LIMIT 5 [ RunTime:0.002137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650651 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650651 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650651 LIMIT 2 [ RunTime:0.001273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650651 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642648 LIMIT 5 [ RunTime:0.001080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642648 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642648 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642648 LIMIT 2 [ RunTime:0.002964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642648 ORDER BY `minOrder` ASC [ RunTime:0.003344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431732 LIMIT 5 [ RunTime:0.002903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431732 ORDER BY `minOrder` ASC [ RunTime:0.003541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431732 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431732 LIMIT 2 [ RunTime:0.001677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431732 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417967 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417967 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417967 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417967 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417967 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001344s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477795 LIMIT 5 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477795 ORDER BY `minOrder` ASC [ RunTime:0.001621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477795 ORDER BY `unit` DESC [ RunTime:0.003375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477795 LIMIT 2 [ RunTime:0.007995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477795 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='1945119' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007357s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945119' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477790 LIMIT 5 [ RunTime:0.010510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477790 ORDER BY `minOrder` ASC [ RunTime:0.001596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477790 ORDER BY `unit` DESC [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477790 LIMIT 2 [ RunTime:0.007084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477790 ORDER BY `minOrder` ASC [ RunTime:0.002658s ]
select * from pdf where partno='1945106' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945106' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478362 LIMIT 5 [ RunTime:0.020173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478362 ORDER BY `minOrder` ASC [ RunTime:0.006439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478362 ORDER BY `unit` DESC [ RunTime:0.004022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478362 LIMIT 2 [ RunTime:0.001754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478362 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='1945122' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945122' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477825 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477825 ORDER BY `minOrder` ASC [ RunTime:0.003517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477825 ORDER BY `unit` DESC [ RunTime:0.009248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477825 LIMIT 2 [ RunTime:0.005714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477825 ORDER BY `minOrder` ASC [ RunTime:0.006868s ]
select * from pdf where partno='1945151' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945151' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479803 LIMIT 5 [ RunTime:0.006489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479803 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479803 ORDER BY `unit` DESC [ RunTime:0.009667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479803 LIMIT 2 [ RunTime:0.009631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479803 ORDER BY `minOrder` ASC [ RunTime:0.008641s ]
select * from pdf where partno='1945148' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945148' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484532 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484532 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484532 ORDER BY `unit` DESC [ RunTime:0.003033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484532 LIMIT 2 [ RunTime:0.006614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484532 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
select * from pdf where partno='1945135' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945135' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484533 LIMIT 5 [ RunTime:0.011864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484533 ORDER BY `minOrder` ASC [ RunTime:0.005557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484533 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484533 LIMIT 2 [ RunTime:0.002090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484533 ORDER BY `minOrder` ASC [ RunTime:0.002966s ]
select * from pdf where partno='1945177' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945177' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478546 LIMIT 5 [ RunTime:0.003467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478546 ORDER BY `minOrder` ASC [ RunTime:0.000964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478546 ORDER BY `unit` DESC [ RunTime:0.001020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478546 LIMIT 2 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478546 ORDER BY `minOrder` ASC [ RunTime:0.003190s ]
select * from pdf where partno='1945193' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945193' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484091 LIMIT 5 [ RunTime:0.005648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484091 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484091 ORDER BY `unit` DESC [ RunTime:0.004461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484091 LIMIT 2 [ RunTime:0.002264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484091 ORDER BY `minOrder` ASC [ RunTime:0.005808s ]
select * from pdf where partno='1945120000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945120000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003740s ]
SELECT `id` FROM `stock` WHERE `id` <> 60484091 AND `partno` = '1945120000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641357 [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60487025 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487025 ORDER BY `minOrder` ASC [ RunTime:0.001470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60487025 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60487025 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487025 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='1945140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000353s ]
SELECT `id` FROM `stock` WHERE `id` <> 60487025 AND `partno` = '1945140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19625570 [ RunTime:0.002889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60486690 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60486690 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60486690 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60486690 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60486690 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='1945180' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945180' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60486920 LIMIT 5 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60486920 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60486920 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60486920 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60486920 ORDER BY `minOrder` ASC [ RunTime:0.001468s ]
select * from pdf where partno='1945160000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945160000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000283s ]
SELECT `id` FROM `stock` WHERE `id` <> 60486920 AND `partno` = '1945160000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19662699 [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64049819 LIMIT 5 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049819 ORDER BY `minOrder` ASC [ RunTime:0.002859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64049819 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64049819 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049819 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='19451' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19451' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000333s ]
SELECT `id` FROM `stock` WHERE `id` <> 64049819 AND `partno` = '19451' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11337051 [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63152973 LIMIT 5 [ RunTime:0.002654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152973 ORDER BY `minOrder` ASC [ RunTime:0.004634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63152973 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63152973 LIMIT 2 [ RunTime:0.001741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152973 ORDER BY `minOrder` ASC [ RunTime:0.003244s ]
select * from pdf where partno='19451.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.008031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19451.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.002061s ]
SELECT `id` FROM `stock` WHERE `id` <> 63152973 AND `partno` = '19451.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.001074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414833 [ RunTime:0.008673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149824 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149824 ORDER BY `minOrder` ASC [ RunTime:0.001031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149824 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149824 LIMIT 2 [ RunTime:0.002725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149824 ORDER BY `minOrder` ASC [ RunTime:0.009971s ]
select * from pdf where partno='19451.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.012819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19451.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.000771s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149824 AND `partno` = '19451.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543641 [ RunTime:0.000906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63148190 LIMIT 5 [ RunTime:0.006010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63148190 ORDER BY `minOrder` ASC [ RunTime:0.027670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63148190 ORDER BY `unit` DESC [ RunTime:0.017555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63148190 LIMIT 2 [ RunTime:0.013566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63148190 ORDER BY `minOrder` ASC [ RunTime:0.011010s ]
select * from pdf where partno='19451.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.001107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19451.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.001060s ]
SELECT `id` FROM `stock` WHERE `id` <> 63148190 AND `partno` = '19451.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431732 [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63147987 LIMIT 5 [ RunTime:0.011057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63147987 ORDER BY `minOrder` ASC [ RunTime:0.004037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63147987 ORDER BY `unit` DESC [ RunTime:0.006387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63147987 LIMIT 2 [ RunTime:0.004803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63147987 ORDER BY `minOrder` ASC [ RunTime:0.008286s ]
select * from pdf where partno='19451.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.008496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19451.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.008312s ]
SELECT `id` FROM `stock` WHERE `id` <> 63147987 AND `partno` = '19451.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417967 [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60551810 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60551810 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60551810 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60551810 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60551810 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='1945180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000440s ]
SELECT `id` FROM `stock` WHERE `id` <> 60551810 AND `partno` = '1945180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19653001 [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60548566 LIMIT 5 [ RunTime:0.004161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60548566 ORDER BY `minOrder` ASC [ RunTime:0.007288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60548566 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60548566 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60548566 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='1945150000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945150000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id` FROM `stock` WHERE `id` <> 60548566 AND `partno` = '1945150000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650651 [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60545246 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60545246 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60545246 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60545246 LIMIT 2 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60545246 ORDER BY `minOrder` ASC [ RunTime:0.011098s ]
select * from pdf where partno='1945130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945130000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000505s ]
SELECT `id` FROM `stock` WHERE `id` <> 60545246 AND `partno` = '1945130000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606232 [ RunTime:0.000439s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001555s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002510s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007731s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005296s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016084s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008589s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001504s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19451%' OR `brand` LIKE '19451%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001388s ]