SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002489s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013296s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779690 LIMIT 5 [ RunTime:0.000775s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779690 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16779690 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16779690 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16779690 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512009 LIMIT 5 [ RunTime:0.001283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512009 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13512009 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13512009 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512009 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12521694 LIMIT 5 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12521694 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12521694 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12521694 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12521694 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12525888 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12525888 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12525888 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12525888 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12525888 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14847668 LIMIT 5 [ RunTime:0.000827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14847668 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14847668 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14847668 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14847668 ORDER BY `minOrder` ASC [ RunTime:0.000228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18707491 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18707491 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18707491 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18707491 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18707491 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18397743 LIMIT 5 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18397743 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18397743 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18397743 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18397743 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
select * from pdf where partno='CB10KB15R0' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.001471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18397742 LIMIT 5 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18397742 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18397742 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18397742 LIMIT 2 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18397742 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='CB10JB250R' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18397736 LIMIT 5 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18397736 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18397736 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18397736 LIMIT 2 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18397736 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='CB10JB470R' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18395653 LIMIT 5 [ RunTime:0.001997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18395653 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18395653 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18395653 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18395653 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18395652 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18395652 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18395652 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18395652 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18395652 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18395651 LIMIT 5 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18395651 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18395651 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18395651 LIMIT 2 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18395651 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394360 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394360 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394360 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394360 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394360 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='CB10JB8R20' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394359 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394359 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394359 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394359 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394359 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='CB10JB6R80' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394358 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394358 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394358 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394358 LIMIT 2 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394358 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
select * from pdf where partno='CB10JB51R0' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394357 LIMIT 5 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394357 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394357 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394357 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394357 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='CB10JB5R60' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394356 LIMIT 5 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394356 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394356 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394356 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394356 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='CB10JB5R10' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394355 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394355 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394355 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394355 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394355 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='CB10JB5R00' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394354 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394354 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394354 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394354 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394354 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='CB10JB43R0' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18394353 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394353 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18394353 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18394353 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18394353 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
select * from pdf where partno='CB10JB4R30' and brandshort='Stackpole Electronics Inc' limit 1 [ RunTime:0.000474s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001130s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58089352 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58089352 ORDER BY `minOrder` ASC [ RunTime:0.000916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58089352 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58089352 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58089352 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='CB10LH105M' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.000979s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10LH105M' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.001056s ]
SELECT `id` FROM `stock` WHERE `id` <> 58089352 AND `partno` = 'CB10LH105M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16779690 [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60429113 LIMIT 5 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429113 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60429113 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60429113 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429113 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
select * from pdf where partno='CB10221407LT1' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.001413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10221407LT1' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.000589s ]
SELECT `id` FROM `stock` WHERE `id` <> 60429113 AND `partno` = 'CB10221407LT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12521694 [ RunTime:0.000371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60429881 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429881 ORDER BY `minOrder` ASC [ RunTime:0.000859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60429881 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60429881 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429881 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
select * from pdf where partno='CB10220707' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.000694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10220707' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.000442s ]
SELECT `id` FROM `stock` WHERE `id` <> 60429881 AND `partno` = 'CB10220707' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12525888 [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524358 LIMIT 5 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524358 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524358 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524358 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524358 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='CB10' and brandshort='FLIR Extech' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10' OR `brand` LIKE 'FLIR Extech%' ) ) LIMIT 1 [ RunTime:0.000597s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524358 AND `partno` = 'CB10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flir extech%' ) [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14847668 [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453119 LIMIT 5 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453119 ORDER BY `minOrder` ASC [ RunTime:0.000937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453119 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453119 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453119 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='CB10-KIT' and brandshort='FLIR Extech' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10-KIT' OR `brand` LIKE 'FLIR Extech%' ) ) LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453119 AND `partno` = 'CB10-KIT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flir extech%' ) [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18707491 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64313271 LIMIT 5 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64313271 ORDER BY `minOrder` ASC [ RunTime:0.000845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64313271 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64313271 LIMIT 2 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64313271 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='CB101N' and brandshort='XP Power' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB101N' OR `brand` LIKE 'XP Power%' ) ) LIMIT 1 [ RunTime:0.001465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64313270 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64313270 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64313270 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64313270 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64313270 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
select * from pdf where partno='CB101' and brandshort='XP Power' limit 1 [ RunTime:0.000474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB101' OR `brand` LIKE 'XP Power%' ) ) LIMIT 1 [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60620704 LIMIT 5 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60620704 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60620704 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60620704 LIMIT 2 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60620704 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='CB1052-000' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB1052-000' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000390s ]
SELECT `id` FROM `stock` WHERE `id` <> 60620704 AND `partno` = 'CB1052-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16357417 [ RunTime:0.000965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58419013 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58419013 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58419013 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58419013 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58419013 ORDER BY `minOrder` ASC [ RunTime:0.000172s ]
select * from pdf where partno='CB105-52' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB105-52' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000400s ]
SELECT `id` FROM `stock` WHERE `id` <> 58419013 AND `partno` = 'CB105-52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58417790 LIMIT 5 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58417790 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58417790 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58417790 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58417790 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='CB101-73' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB101-73' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000421s ]
SELECT `id` FROM `stock` WHERE `id` <> 58417790 AND `partno` = 'CB101-73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11364162 [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58417511 LIMIT 5 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58417511 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58417511 ORDER BY `unit` DESC [ RunTime:0.000320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58417511 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58417511 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
select * from pdf where partno='CB101-52' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB101-52' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000411s ]
SELECT `id` FROM `stock` WHERE `id` <> 58417511 AND `partno` = 'CB101-52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58416642 LIMIT 5 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58416642 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58416642 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58416642 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58416642 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
select * from pdf where partno='CB101-78' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB101-78' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000404s ]
SELECT `id` FROM `stock` WHERE `id` <> 58416642 AND `partno` = 'CB101-78' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58416466 LIMIT 5 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58416466 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58416466 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58416466 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58416466 ORDER BY `minOrder` ASC [ RunTime:0.000205s ]
select * from pdf where partno='CB101-73/HDW ASSM' and brandshort='Carling Technologies' limit 1 [ RunTime:0.000393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB101-73/HDW ASSM' OR `brand` LIKE 'Carling Technologies%' ) ) LIMIT 1 [ RunTime:0.000386s ]
SELECT `id` FROM `stock` WHERE `id` <> 58416466 AND `partno` = 'CB101-73/HDW ASSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carling technologies%' ) [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58203236 LIMIT 5 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58203236 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58203236 ORDER BY `unit` DESC [ RunTime:0.000267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58203236 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58203236 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='CB1038-3/L' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB1038-3/L' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT `id` FROM `stock` WHERE `id` <> 58203236 AND `partno` = 'CB1038-3/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13817757 [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58202904 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202904 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58202904 ORDER BY `unit` DESC [ RunTime:0.000263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58202904 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202904 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
select * from pdf where partno='CB1038-2/L' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB1038-2/L' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.000470s ]
SELECT `id` FROM `stock` WHERE `id` <> 58202904 AND `partno` = 'CB1038-2/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708088 [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58202331 LIMIT 5 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202331 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58202331 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58202331 LIMIT 2 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202331 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
select * from pdf where partno='CB1038-1N' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB1038-1N' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.000497s ]
SELECT `id` FROM `stock` WHERE `id` <> 58202331 AND `partno` = 'CB1038-1N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14707816 [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58090340 LIMIT 5 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090340 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58090340 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58090340 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090340 ORDER BY `minOrder` ASC [ RunTime:0.000206s ]
select * from pdf where partno='CB10MV103ME' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.000416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10MV103ME' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.000325s ]
SELECT `id` FROM `stock` WHERE `id` <> 58090340 AND `partno` = 'CB10MV103ME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14048946 [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58090339 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090339 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58090339 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58090339 LIMIT 2 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090339 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
select * from pdf where partno='CB10MH474K' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.000340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10MH474K' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.000310s ]
SELECT `id` FROM `stock` WHERE `id` <> 58090339 AND `partno` = 'CB10MH474K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17766688 [ RunTime:0.000793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58090338 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090338 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58090338 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58090338 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090338 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
select * from pdf where partno='CB10MH105K' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.000416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10MH105K' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.000321s ]
SELECT `id` FROM `stock` WHERE `id` <> 58090338 AND `partno` = 'CB10MH105K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15679316 [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58090139 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090139 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58090139 ORDER BY `unit` DESC [ RunTime:0.000261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58090139 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58090139 ORDER BY `minOrder` ASC [ RunTime:0.000177s ]
select * from pdf where partno='CB10LV222M' and brandshort='TE Connectivity Passive Product' limit 1 [ RunTime:0.000357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CB10LV222M' OR `brand` LIKE 'TE Connectivity Passive Product%' ) ) LIMIT 1 [ RunTime:0.000310s ]
SELECT `id` FROM `stock` WHERE `id` <> 58090139 AND `partno` = 'CB10LV222M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity passive product%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14048890 [ RunTime:0.000460s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000637s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000525s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000552s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000513s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000494s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000493s ]
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 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000575s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CB10%' OR `brand` LIKE 'CB10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001316s ]