SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002319s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015077s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348370 LIMIT 5 [ RunTime:0.018419s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348370 ORDER BY `minOrder` ASC [ RunTime:0.006529s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348370 ORDER BY `unit` DESC [ RunTime:0.027880s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348370 LIMIT 2 [ RunTime:0.019582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348370 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190427 LIMIT 5 [ RunTime:0.016647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190427 ORDER BY `minOrder` ASC [ RunTime:0.008486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190427 ORDER BY `unit` DESC [ RunTime:0.017559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190427 LIMIT 2 [ RunTime:0.047181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190427 ORDER BY `minOrder` ASC [ RunTime:0.014155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975229 LIMIT 5 [ RunTime:0.026233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975229 ORDER BY `minOrder` ASC [ RunTime:0.036145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975229 ORDER BY `unit` DESC [ RunTime:0.045805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975229 LIMIT 2 [ RunTime:0.038835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975229 ORDER BY `minOrder` ASC [ RunTime:0.014270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786042 LIMIT 5 [ RunTime:0.032073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786042 ORDER BY `minOrder` ASC [ RunTime:0.006777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786042 ORDER BY `unit` DESC [ RunTime:0.007688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786042 LIMIT 2 [ RunTime:0.027031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786042 ORDER BY `minOrder` ASC [ RunTime:0.018505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786036 LIMIT 5 [ RunTime:0.055476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786036 ORDER BY `minOrder` ASC [ RunTime:0.055836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786036 ORDER BY `unit` DESC [ RunTime:0.025331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786036 LIMIT 2 [ RunTime:0.039718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786036 ORDER BY `minOrder` ASC [ RunTime:0.013322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18782330 LIMIT 5 [ RunTime:0.025169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18782330 ORDER BY `minOrder` ASC [ RunTime:0.042298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18782330 ORDER BY `unit` DESC [ RunTime:0.029504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18782330 LIMIT 2 [ RunTime:0.040853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18782330 ORDER BY `minOrder` ASC [ RunTime:0.022909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781996 LIMIT 5 [ RunTime:0.023191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781996 ORDER BY `minOrder` ASC [ RunTime:0.019128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781996 ORDER BY `unit` DESC [ RunTime:0.005122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781996 LIMIT 2 [ RunTime:0.016837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781996 ORDER BY `minOrder` ASC [ RunTime:0.022563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780293 LIMIT 5 [ RunTime:0.020474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780293 ORDER BY `minOrder` ASC [ RunTime:0.009592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780293 ORDER BY `unit` DESC [ RunTime:0.005480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780293 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780293 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774963 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774963 ORDER BY `minOrder` ASC [ RunTime:0.008900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774963 ORDER BY `unit` DESC [ RunTime:0.003066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774963 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774963 ORDER BY `minOrder` ASC [ RunTime:0.001719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774485 LIMIT 5 [ RunTime:0.003743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774485 ORDER BY `minOrder` ASC [ RunTime:0.005760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774485 ORDER BY `unit` DESC [ RunTime:0.011343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774485 LIMIT 2 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774485 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774484 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774484 ORDER BY `minOrder` ASC [ RunTime:0.019803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774484 ORDER BY `unit` DESC [ RunTime:0.005439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774484 LIMIT 2 [ RunTime:0.040017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774484 ORDER BY `minOrder` ASC [ RunTime:0.011564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772247 LIMIT 5 [ RunTime:0.029234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772247 ORDER BY `minOrder` ASC [ RunTime:0.013402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772247 ORDER BY `unit` DESC [ RunTime:0.015731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772247 LIMIT 2 [ RunTime:0.007018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772247 ORDER BY `minOrder` ASC [ RunTime:0.002864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771214 LIMIT 5 [ RunTime:0.009439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771214 ORDER BY `minOrder` ASC [ RunTime:0.019596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771214 ORDER BY `unit` DESC [ RunTime:0.004382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771214 LIMIT 2 [ RunTime:0.011530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771214 ORDER BY `minOrder` ASC [ RunTime:0.002311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771212 LIMIT 5 [ RunTime:0.002690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771212 ORDER BY `minOrder` ASC [ RunTime:0.009979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771212 ORDER BY `unit` DESC [ RunTime:0.019030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771212 LIMIT 2 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771212 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048863 LIMIT 5 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048863 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17048863 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17048863 LIMIT 2 [ RunTime:0.006408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048863 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223923 LIMIT 5 [ RunTime:0.002638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223923 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223923 ORDER BY `unit` DESC [ RunTime:0.000228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223923 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223923 ORDER BY `minOrder` ASC [ RunTime:0.005904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13525661 LIMIT 5 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525661 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13525661 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13525661 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525661 ORDER BY `minOrder` ASC [ RunTime:0.002152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524937 LIMIT 5 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524937 ORDER BY `minOrder` ASC [ RunTime:0.007124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524937 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524937 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524937 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12551349 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12551349 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12551349 ORDER BY `unit` DESC [ RunTime:0.000234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12551349 LIMIT 2 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12551349 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175669 LIMIT 5 [ RunTime:0.011750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175669 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175669 ORDER BY `unit` DESC [ RunTime:0.002053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175669 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175669 ORDER BY `minOrder` ASC [ RunTime:0.001833s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006765s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558327 LIMIT 5 [ RunTime:0.001225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558327 ORDER BY `minOrder` ASC [ RunTime:0.010513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558327 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558327 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558327 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='10946CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000987s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10946CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001741s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558327 AND `partno` = '10946CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348370 [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54286590 LIMIT 5 [ RunTime:0.007765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54286590 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54286590 ORDER BY `unit` DESC [ RunTime:0.000361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54286590 LIMIT 2 [ RunTime:0.001533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54286590 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
select * from pdf where partno='109467-90' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109467-90' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000864s ]
SELECT `id` FROM `stock` WHERE `id` <> 54286590 AND `partno` = '109467-90' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54283319 LIMIT 5 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54283319 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54283319 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54283319 LIMIT 2 [ RunTime:0.001847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54283319 ORDER BY `minOrder` ASC [ RunTime:0.002114s ]
select * from pdf where partno='109464-90' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.006975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109464-90' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.003027s ]
SELECT `id` FROM `stock` WHERE `id` <> 54283319 AND `partno` = '109464-90' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63334291 LIMIT 5 [ RunTime:0.001147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334291 ORDER BY `minOrder` ASC [ RunTime:0.001653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63334291 ORDER BY `unit` DESC [ RunTime:0.001887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63334291 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334291 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='1094676' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094676' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001084s ]
SELECT `id` FROM `stock` WHERE `id` <> 63334291 AND `partno` = '1094676' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190427 [ RunTime:0.003117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807468 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807468 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807468 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807468 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807468 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='1094614' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094614' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000365s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807468 AND `partno` = '1094614' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223923 [ RunTime:0.000319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807362 LIMIT 5 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807362 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807362 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807362 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807362 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='1094613' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094613' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000326s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807362 AND `partno` = '1094613' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774963 [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806659 LIMIT 5 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806659 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806659 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806659 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806659 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='1094612' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094612' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000489s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806659 AND `partno` = '1094612' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774485 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806658 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806658 ORDER BY `minOrder` ASC [ RunTime:0.004266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806658 ORDER BY `unit` DESC [ RunTime:0.005577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806658 LIMIT 2 [ RunTime:0.003076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806658 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='1094639' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094639' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003196s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806658 AND `partno` = '1094639' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774484 [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802390 LIMIT 5 [ RunTime:0.001159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802390 ORDER BY `minOrder` ASC [ RunTime:0.014414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802390 ORDER BY `unit` DESC [ RunTime:0.013492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802390 LIMIT 2 [ RunTime:0.004109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802390 ORDER BY `minOrder` ASC [ RunTime:0.002901s ]
select * from pdf where partno='1094602' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094602' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001890s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802390 AND `partno` = '1094602' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772247 [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800984 LIMIT 5 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800984 ORDER BY `minOrder` ASC [ RunTime:0.001329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800984 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800984 LIMIT 2 [ RunTime:0.001977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800984 ORDER BY `minOrder` ASC [ RunTime:0.006356s ]
select * from pdf where partno='1094652' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094652' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000855s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800984 AND `partno` = '1094652' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771214 [ RunTime:0.005743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800983 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800983 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800983 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800983 LIMIT 2 [ RunTime:0.002940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800983 ORDER BY `minOrder` ASC [ RunTime:0.005466s ]
select * from pdf where partno='1094651' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094651' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005800s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800983 AND `partno` = '1094651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771212 [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64516028 LIMIT 5 [ RunTime:0.003427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64516028 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64516028 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64516028 LIMIT 2 [ RunTime:0.006027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64516028 ORDER BY `minOrder` ASC [ RunTime:0.008996s ]
select * from pdf where partno='109468' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109468' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015759s ]
SELECT `id` FROM `stock` WHERE `id` <> 64516028 AND `partno` = '109468' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13525661 [ RunTime:0.023257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514838 LIMIT 5 [ RunTime:0.027939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514838 ORDER BY `minOrder` ASC [ RunTime:0.018459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514838 ORDER BY `unit` DESC [ RunTime:0.028088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514838 LIMIT 2 [ RunTime:0.029937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514838 ORDER BY `minOrder` ASC [ RunTime:0.026068s ]
select * from pdf where partno='109467' and brandshort='Brady Corporation' limit 1 [ RunTime:0.013758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109467' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027267s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514838 AND `partno` = '109467' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524937 [ RunTime:0.023437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345486 LIMIT 5 [ RunTime:0.024284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345486 ORDER BY `minOrder` ASC [ RunTime:0.033453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345486 ORDER BY `unit` DESC [ RunTime:0.022936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345486 LIMIT 2 [ RunTime:0.041715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345486 ORDER BY `minOrder` ASC [ RunTime:0.025556s ]
select * from pdf where partno='1094671' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094671' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.052192s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345486 AND `partno` = '1094671' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780293 [ RunTime:0.029567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63339535 LIMIT 5 [ RunTime:0.032253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339535 ORDER BY `minOrder` ASC [ RunTime:0.003761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63339535 ORDER BY `unit` DESC [ RunTime:0.033603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63339535 LIMIT 2 [ RunTime:0.038142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339535 ORDER BY `minOrder` ASC [ RunTime:0.023772s ]
select * from pdf where partno='1094601' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094601' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002464s ]
SELECT `id` FROM `stock` WHERE `id` <> 63339535 AND `partno` = '1094601' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786042 [ RunTime:0.022202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63339529 LIMIT 5 [ RunTime:0.041597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339529 ORDER BY `minOrder` ASC [ RunTime:0.031496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63339529 ORDER BY `unit` DESC [ RunTime:0.031070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63339529 LIMIT 2 [ RunTime:0.027089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339529 ORDER BY `minOrder` ASC [ RunTime:0.010529s ]
select * from pdf where partno='1094695' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094695' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014176s ]
SELECT `id` FROM `stock` WHERE `id` <> 63339529 AND `partno` = '1094695' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786036 [ RunTime:0.021290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63314269 LIMIT 5 [ RunTime:0.010860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314269 ORDER BY `minOrder` ASC [ RunTime:0.018789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63314269 ORDER BY `unit` DESC [ RunTime:0.026314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63314269 LIMIT 2 [ RunTime:0.019335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314269 ORDER BY `minOrder` ASC [ RunTime:0.007256s ]
select * from pdf where partno='1094617' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094617' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008446s ]
SELECT `id` FROM `stock` WHERE `id` <> 63314269 AND `partno` = '1094617' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958405 [ RunTime:0.009225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63279052 LIMIT 5 [ RunTime:0.019176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63279052 ORDER BY `minOrder` ASC [ RunTime:0.011147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63279052 ORDER BY `unit` DESC [ RunTime:0.012333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63279052 LIMIT 2 [ RunTime:0.015563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63279052 ORDER BY `minOrder` ASC [ RunTime:0.014017s ]
select * from pdf where partno='1094699' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094699' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006431s ]
SELECT `id` FROM `stock` WHERE `id` <> 63279052 AND `partno` = '1094699' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63279051 LIMIT 5 [ RunTime:0.004198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63279051 ORDER BY `minOrder` ASC [ RunTime:0.006232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63279051 ORDER BY `unit` DESC [ RunTime:0.011796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63279051 LIMIT 2 [ RunTime:0.003069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63279051 ORDER BY `minOrder` ASC [ RunTime:0.006314s ]
select * from pdf where partno='1094698' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094698' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003535s ]
SELECT `id` FROM `stock` WHERE `id` <> 63279051 AND `partno` = '1094698' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11673985 [ RunTime:0.017597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63201110 LIMIT 5 [ RunTime:0.040783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201110 ORDER BY `minOrder` ASC [ RunTime:0.027089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63201110 ORDER BY `unit` DESC [ RunTime:0.007675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63201110 LIMIT 2 [ RunTime:0.002329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201110 ORDER BY `minOrder` ASC [ RunTime:0.004008s ]
select * from pdf where partno='1094690' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1094690' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001395s ]
SELECT `id` FROM `stock` WHERE `id` <> 63201110 AND `partno` = '1094690' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975229 [ RunTime:0.035686s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011934s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011257s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005483s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016740s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036212s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025776s ]
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 '10946%' OR `brand` LIKE '10946%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027421s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10946%' OR `brand` LIKE '10946%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014613s ]