SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001254s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033375s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066825 LIMIT 5 [ RunTime:0.035936s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066825 ORDER BY `minOrder` ASC [ RunTime:0.012491s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066825 ORDER BY `unit` DESC [ RunTime:0.011711s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066825 LIMIT 2 [ RunTime:0.018256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066825 ORDER BY `minOrder` ASC [ RunTime:0.045291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077020 LIMIT 5 [ RunTime:0.009611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077020 ORDER BY `minOrder` ASC [ RunTime:0.012153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077020 ORDER BY `unit` DESC [ RunTime:0.034414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077020 LIMIT 2 [ RunTime:0.021404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077020 ORDER BY `minOrder` ASC [ RunTime:0.021895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659916 LIMIT 5 [ RunTime:0.023081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659916 ORDER BY `minOrder` ASC [ RunTime:0.019298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659916 ORDER BY `unit` DESC [ RunTime:0.047504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659916 LIMIT 2 [ RunTime:0.032339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659916 ORDER BY `minOrder` ASC [ RunTime:0.010377s ]
select * from pdf where partno='1081150000' and brandshort='Weidmüller' limit 1 [ RunTime:0.040655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11854486 LIMIT 5 [ RunTime:0.041049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854486 ORDER BY `minOrder` ASC [ RunTime:0.010805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11854486 ORDER BY `unit` DESC [ RunTime:0.006485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11854486 LIMIT 2 [ RunTime:0.035234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854486 ORDER BY `minOrder` ASC [ RunTime:0.018584s ]
select * from pdf where partno='1081180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022945 LIMIT 5 [ RunTime:0.011380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022945 ORDER BY `minOrder` ASC [ RunTime:0.012530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19022945 ORDER BY `unit` DESC [ RunTime:0.005387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19022945 LIMIT 2 [ RunTime:0.003465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022945 ORDER BY `minOrder` ASC [ RunTime:0.014639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022911 LIMIT 5 [ RunTime:0.013048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022911 ORDER BY `minOrder` ASC [ RunTime:0.057505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19022911 ORDER BY `unit` DESC [ RunTime:0.019507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19022911 LIMIT 2 [ RunTime:0.026086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022911 ORDER BY `minOrder` ASC [ RunTime:0.023045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13109005 LIMIT 5 [ RunTime:0.054071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13109005 ORDER BY `minOrder` ASC [ RunTime:0.102213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13109005 ORDER BY `unit` DESC [ RunTime:0.052400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13109005 LIMIT 2 [ RunTime:0.057537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13109005 ORDER BY `minOrder` ASC [ RunTime:0.002045s ]
select * from pdf where partno='1081190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080845 LIMIT 5 [ RunTime:0.012537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080845 ORDER BY `minOrder` ASC [ RunTime:0.012040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080845 ORDER BY `unit` DESC [ RunTime:0.019242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080845 LIMIT 2 [ RunTime:0.002629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080845 ORDER BY `minOrder` ASC [ RunTime:0.002763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982466 LIMIT 5 [ RunTime:0.004455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982466 ORDER BY `minOrder` ASC [ RunTime:0.006310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982466 ORDER BY `unit` DESC [ RunTime:0.009142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982466 LIMIT 2 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982466 ORDER BY `minOrder` ASC [ RunTime:0.002852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981683 LIMIT 5 [ RunTime:0.005265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981683 ORDER BY `minOrder` ASC [ RunTime:0.003425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981683 ORDER BY `unit` DESC [ RunTime:0.006169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981683 LIMIT 2 [ RunTime:0.003396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981683 ORDER BY `minOrder` ASC [ RunTime:0.008269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981358 LIMIT 5 [ RunTime:0.004500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981358 ORDER BY `minOrder` ASC [ RunTime:0.011585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981358 ORDER BY `unit` DESC [ RunTime:0.019276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981358 LIMIT 2 [ RunTime:0.016141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981358 ORDER BY `minOrder` ASC [ RunTime:0.001495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979278 LIMIT 5 [ RunTime:0.005671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979278 ORDER BY `minOrder` ASC [ RunTime:0.004697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979278 ORDER BY `unit` DESC [ RunTime:0.001358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979278 LIMIT 2 [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979278 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979214 LIMIT 5 [ RunTime:0.003647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979214 ORDER BY `minOrder` ASC [ RunTime:0.001961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979214 ORDER BY `unit` DESC [ RunTime:0.014049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979214 LIMIT 2 [ RunTime:0.013049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979214 ORDER BY `minOrder` ASC [ RunTime:0.011794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18978829 LIMIT 5 [ RunTime:0.008384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978829 ORDER BY `minOrder` ASC [ RunTime:0.000862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18978829 ORDER BY `unit` DESC [ RunTime:0.003331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18978829 LIMIT 2 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978829 ORDER BY `minOrder` ASC [ RunTime:0.001949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797029 LIMIT 5 [ RunTime:0.005496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797029 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797029 ORDER BY `unit` DESC [ RunTime:0.000319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797029 LIMIT 2 [ RunTime:0.005601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797029 ORDER BY `minOrder` ASC [ RunTime:0.005829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786875 LIMIT 5 [ RunTime:0.029400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786875 ORDER BY `minOrder` ASC [ RunTime:0.011164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786875 ORDER BY `unit` DESC [ RunTime:0.005650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786875 LIMIT 2 [ RunTime:0.008804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786875 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786672 LIMIT 5 [ RunTime:0.009147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786672 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786672 ORDER BY `unit` DESC [ RunTime:0.014096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786672 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786672 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780218 LIMIT 5 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780218 ORDER BY `minOrder` ASC [ RunTime:0.009512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780218 ORDER BY `unit` DESC [ RunTime:0.004426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780218 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780218 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780093 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780093 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780093 ORDER BY `unit` DESC [ RunTime:0.002404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780093 LIMIT 2 [ RunTime:0.004252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780093 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778968 LIMIT 5 [ RunTime:0.004161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778968 ORDER BY `minOrder` ASC [ RunTime:0.005705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778968 ORDER BY `unit` DESC [ RunTime:0.004893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778968 LIMIT 2 [ RunTime:0.010683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778968 ORDER BY `minOrder` ASC [ RunTime:0.003272s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080507 LIMIT 5 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080507 ORDER BY `minOrder` ASC [ RunTime:0.015742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080507 ORDER BY `unit` DESC [ RunTime:0.001118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080507 LIMIT 2 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080507 ORDER BY `minOrder` ASC [ RunTime:0.003201s ]
select * from pdf where partno='108117' and brandshort='basler' limit 1 [ RunTime:0.002828s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108117' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.003187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080368 LIMIT 5 [ RunTime:0.006254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080368 ORDER BY `minOrder` ASC [ RunTime:0.001726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080368 ORDER BY `unit` DESC [ RunTime:0.005702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080368 LIMIT 2 [ RunTime:0.002179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080368 ORDER BY `minOrder` ASC [ RunTime:0.001991s ]
select * from pdf where partno='108119' and brandshort='basler' limit 1 [ RunTime:0.000747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108119' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.006267s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559105 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559105 ORDER BY `minOrder` ASC [ RunTime:0.000803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559105 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559105 LIMIT 2 [ RunTime:0.002054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559105 ORDER BY `minOrder` ASC [ RunTime:0.003589s ]
select * from pdf where partno='10811CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10811CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000652s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559105 AND `partno` = '10811CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066825 [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009529 LIMIT 5 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009529 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009529 ORDER BY `unit` DESC [ RunTime:0.000260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009529 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009529 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='10811' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10811' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000285s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009529 AND `partno` = '10811' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077020 [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400406 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400406 ORDER BY `minOrder` ASC [ RunTime:0.008386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400406 ORDER BY `unit` DESC [ RunTime:0.001420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400406 LIMIT 2 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400406 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='1081180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002007s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400406 AND `partno` = '1081180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11854486 [ RunTime:0.004586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64484133 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484133 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64484133 ORDER BY `unit` DESC [ RunTime:0.000750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64484133 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484133 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='10811110700' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.000420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10811110700' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.000270s ]
SELECT `id` FROM `stock` WHERE `id` <> 64484133 AND `partno` = '10811110700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.002256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022911 [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64484127 LIMIT 5 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484127 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64484127 ORDER BY `unit` DESC [ RunTime:0.001333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64484127 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484127 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='10811111500' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.000388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10811111500' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.000316s ]
SELECT `id` FROM `stock` WHERE `id` <> 64484127 AND `partno` = '10811111500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022945 [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806124 LIMIT 5 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806124 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806124 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806124 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806124 ORDER BY `minOrder` ASC [ RunTime:0.002776s ]
select * from pdf where partno='1081183' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081183' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000573s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806124 AND `partno` = '1081183' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223758 [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805858 LIMIT 5 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805858 ORDER BY `minOrder` ASC [ RunTime:0.009071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805858 ORDER BY `unit` DESC [ RunTime:0.002130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805858 LIMIT 2 [ RunTime:0.001503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805858 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='1081158' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081158' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003410s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805858 AND `partno` = '1081158' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196944 [ RunTime:0.002231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804828 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804828 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804828 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804828 LIMIT 2 [ RunTime:0.007389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804828 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
select * from pdf where partno='1081116' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081116' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000634s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804828 AND `partno` = '1081116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773524 [ RunTime:0.001641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804796 LIMIT 5 [ RunTime:0.005156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804796 ORDER BY `minOrder` ASC [ RunTime:0.006709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804796 ORDER BY `unit` DESC [ RunTime:0.008067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804796 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804796 ORDER BY `minOrder` ASC [ RunTime:0.007772s ]
select * from pdf where partno='1081114' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081114' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009178s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804796 AND `partno` = '1081114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223592 [ RunTime:0.003687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803181 LIMIT 5 [ RunTime:0.016467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803181 ORDER BY `minOrder` ASC [ RunTime:0.017338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803181 ORDER BY `unit` DESC [ RunTime:0.012604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803181 LIMIT 2 [ RunTime:0.007065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803181 ORDER BY `minOrder` ASC [ RunTime:0.004327s ]
select * from pdf where partno='1081128' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081128' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001415s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803181 AND `partno` = '1081128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223407 [ RunTime:0.005038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803004 LIMIT 5 [ RunTime:0.003116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803004 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803004 ORDER BY `unit` DESC [ RunTime:0.003326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803004 LIMIT 2 [ RunTime:0.016352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803004 ORDER BY `minOrder` ASC [ RunTime:0.011103s ]
select * from pdf where partno='1081157' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081157' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009308s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803004 AND `partno` = '1081157' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772414 [ RunTime:0.008355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801346 LIMIT 5 [ RunTime:0.004821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801346 ORDER BY `minOrder` ASC [ RunTime:0.013686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801346 ORDER BY `unit` DESC [ RunTime:0.072133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801346 LIMIT 2 [ RunTime:0.079161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801346 ORDER BY `minOrder` ASC [ RunTime:0.011769s ]
select * from pdf where partno='1081159' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081159' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.162969s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801346 AND `partno` = '1081159' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.119983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771461 [ RunTime:0.017703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800854 LIMIT 5 [ RunTime:0.023147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800854 ORDER BY `minOrder` ASC [ RunTime:0.044177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800854 ORDER BY `unit` DESC [ RunTime:0.045617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800854 LIMIT 2 [ RunTime:0.114147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800854 ORDER BY `minOrder` ASC [ RunTime:0.032514s ]
select * from pdf where partno='1081177' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081177' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018906s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800854 AND `partno` = '1081177' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.050859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771138 [ RunTime:0.021657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800853 LIMIT 5 [ RunTime:0.051274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800853 ORDER BY `minOrder` ASC [ RunTime:0.011280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800853 ORDER BY `unit` DESC [ RunTime:0.025824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800853 LIMIT 2 [ RunTime:0.089259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800853 ORDER BY `minOrder` ASC [ RunTime:0.021296s ]
select * from pdf where partno='1081176' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081176' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039359s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800853 AND `partno` = '1081176' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771137 [ RunTime:0.037664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800831 LIMIT 5 [ RunTime:0.098386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800831 ORDER BY `minOrder` ASC [ RunTime:0.069260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800831 ORDER BY `unit` DESC [ RunTime:0.052001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800831 LIMIT 2 [ RunTime:0.060010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800831 ORDER BY `minOrder` ASC [ RunTime:0.050949s ]
select * from pdf where partno='1081173' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.130034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081173' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.082400s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800831 AND `partno` = '1081173' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.045628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771124 [ RunTime:0.136395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800830 LIMIT 5 [ RunTime:0.071054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800830 ORDER BY `minOrder` ASC [ RunTime:0.021568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800830 ORDER BY `unit` DESC [ RunTime:0.012304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800830 LIMIT 2 [ RunTime:0.092944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800830 ORDER BY `minOrder` ASC [ RunTime:0.108256s ]
select * from pdf where partno='1081175' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.050747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081175' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033403s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800830 AND `partno` = '1081175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771123 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800504 LIMIT 5 [ RunTime:0.157145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800504 ORDER BY `minOrder` ASC [ RunTime:0.139144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800504 ORDER BY `unit` DESC [ RunTime:0.078496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800504 LIMIT 2 [ RunTime:0.079902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800504 ORDER BY `minOrder` ASC [ RunTime:0.028723s ]
select * from pdf where partno='1081117' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.042675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081117' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039978s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800504 AND `partno` = '1081117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.078445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770810 [ RunTime:0.041275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64793493 LIMIT 5 [ RunTime:0.075482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64793493 ORDER BY `minOrder` ASC [ RunTime:0.044335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64793493 ORDER BY `unit` DESC [ RunTime:0.014839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64793493 LIMIT 2 [ RunTime:0.056903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64793493 ORDER BY `minOrder` ASC [ RunTime:0.028808s ]
select * from pdf where partno='1081179' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.040718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081179' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019101s ]
SELECT `id` FROM `stock` WHERE `id` <> 64793493 AND `partno` = '1081179' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797029 [ RunTime:0.019175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64790136 LIMIT 5 [ RunTime:0.014868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64790136 ORDER BY `minOrder` ASC [ RunTime:0.026050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64790136 ORDER BY `unit` DESC [ RunTime:0.027466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64790136 LIMIT 2 [ RunTime:0.054334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64790136 ORDER BY `minOrder` ASC [ RunTime:0.018897s ]
select * from pdf where partno='1081180' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081180' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.044628s ]
SELECT `id` FROM `stock` WHERE `id` <> 64790136 AND `partno` = '1081180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17013777 [ RunTime:0.054660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63382032 LIMIT 5 [ RunTime:0.040158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63382032 ORDER BY `minOrder` ASC [ RunTime:0.063540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63382032 ORDER BY `unit` DESC [ RunTime:0.052531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63382032 LIMIT 2 [ RunTime:0.087833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63382032 ORDER BY `minOrder` ASC [ RunTime:0.008714s ]
select * from pdf where partno='10811F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.041988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10811F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.071856s ]
SELECT `id` FROM `stock` WHERE `id` <> 63382032 AND `partno` = '10811F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.014496s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053549s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006610s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038512s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023412s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037752s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018702s ]
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 '10811%' OR `brand` LIKE '10811%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018404s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10811%' OR `brand` LIKE '10811%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024836s ]