SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002434s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030194s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047258 LIMIT 5 [ RunTime:0.030674s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047258 ORDER BY `minOrder` ASC [ RunTime:0.021309s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047258 ORDER BY `unit` DESC [ RunTime:0.014019s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047258 LIMIT 2 [ RunTime:0.006934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047258 ORDER BY `minOrder` ASC [ RunTime:0.021808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19628099 LIMIT 5 [ RunTime:0.017882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19628099 ORDER BY `minOrder` ASC [ RunTime:0.039517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19628099 ORDER BY `unit` DESC [ RunTime:0.017983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19628099 LIMIT 2 [ RunTime:0.027488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19628099 ORDER BY `minOrder` ASC [ RunTime:0.009712s ]
select * from pdf where partno='1065110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.006359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19628100 LIMIT 5 [ RunTime:0.016498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19628100 ORDER BY `minOrder` ASC [ RunTime:0.036444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19628100 ORDER BY `unit` DESC [ RunTime:0.014613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19628100 LIMIT 2 [ RunTime:0.048595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19628100 ORDER BY `minOrder` ASC [ RunTime:0.004883s ]
select * from pdf where partno='1065180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641364 LIMIT 5 [ RunTime:0.012954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19641364 ORDER BY `minOrder` ASC [ RunTime:0.017349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19641364 ORDER BY `unit` DESC [ RunTime:0.015941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19641364 LIMIT 2 [ RunTime:0.009374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19641364 ORDER BY `minOrder` ASC [ RunTime:0.025728s ]
select * from pdf where partno='1065170000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17312760 LIMIT 5 [ RunTime:0.046778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312760 ORDER BY `minOrder` ASC [ RunTime:0.039281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17312760 ORDER BY `unit` DESC [ RunTime:0.023807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17312760 LIMIT 2 [ RunTime:0.029372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312760 ORDER BY `minOrder` ASC [ RunTime:0.021188s ]
select * from pdf where partno='1065130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.052483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606136 LIMIT 5 [ RunTime:0.035312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606136 ORDER BY `minOrder` ASC [ RunTime:0.051367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606136 ORDER BY `unit` DESC [ RunTime:0.073948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606136 LIMIT 2 [ RunTime:0.033137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606136 ORDER BY `minOrder` ASC [ RunTime:0.040260s ]
select * from pdf where partno='1065160000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190986 LIMIT 5 [ RunTime:0.008370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190986 ORDER BY `minOrder` ASC [ RunTime:0.015595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190986 ORDER BY `unit` DESC [ RunTime:0.011728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190986 LIMIT 2 [ RunTime:0.026450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190986 ORDER BY `minOrder` ASC [ RunTime:0.030634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190676 LIMIT 5 [ RunTime:0.009079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190676 ORDER BY `minOrder` ASC [ RunTime:0.010956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190676 ORDER BY `unit` DESC [ RunTime:0.020034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190676 LIMIT 2 [ RunTime:0.020837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190676 ORDER BY `minOrder` ASC [ RunTime:0.012438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19653897 LIMIT 5 [ RunTime:0.020334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653897 ORDER BY `minOrder` ASC [ RunTime:0.041817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19653897 ORDER BY `unit` DESC [ RunTime:0.027525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19653897 LIMIT 2 [ RunTime:0.039466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653897 ORDER BY `minOrder` ASC [ RunTime:0.011054s ]
select * from pdf where partno='1065190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.112292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982765 LIMIT 5 [ RunTime:0.020170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982765 ORDER BY `minOrder` ASC [ RunTime:0.025020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982765 ORDER BY `unit` DESC [ RunTime:0.006103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982765 LIMIT 2 [ RunTime:0.056450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982765 ORDER BY `minOrder` ASC [ RunTime:0.033004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981950 LIMIT 5 [ RunTime:0.044420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981950 ORDER BY `minOrder` ASC [ RunTime:0.038907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981950 ORDER BY `unit` DESC [ RunTime:0.045516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981950 LIMIT 2 [ RunTime:0.060858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981950 ORDER BY `minOrder` ASC [ RunTime:0.030945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981949 LIMIT 5 [ RunTime:0.041006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981949 ORDER BY `minOrder` ASC [ RunTime:0.024483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981949 ORDER BY `unit` DESC [ RunTime:0.034284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981949 LIMIT 2 [ RunTime:0.026293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981949 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981947 LIMIT 5 [ RunTime:0.037573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981947 ORDER BY `minOrder` ASC [ RunTime:0.034942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981947 ORDER BY `unit` DESC [ RunTime:0.056424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981947 LIMIT 2 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981947 ORDER BY `minOrder` ASC [ RunTime:0.013209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981935 LIMIT 5 [ RunTime:0.018928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981935 ORDER BY `minOrder` ASC [ RunTime:0.042692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981935 ORDER BY `unit` DESC [ RunTime:0.041552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981935 LIMIT 2 [ RunTime:0.037961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981935 ORDER BY `minOrder` ASC [ RunTime:0.090946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981876 LIMIT 5 [ RunTime:0.046857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981876 ORDER BY `minOrder` ASC [ RunTime:0.053020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981876 ORDER BY `unit` DESC [ RunTime:0.042570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981876 LIMIT 2 [ RunTime:0.020254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981876 ORDER BY `minOrder` ASC [ RunTime:0.027724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981684 LIMIT 5 [ RunTime:0.067377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981684 ORDER BY `minOrder` ASC [ RunTime:0.032397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981684 ORDER BY `unit` DESC [ RunTime:0.018668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981684 LIMIT 2 [ RunTime:0.033500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981684 ORDER BY `minOrder` ASC [ RunTime:0.023157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981269 LIMIT 5 [ RunTime:0.006655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981269 ORDER BY `minOrder` ASC [ RunTime:0.004886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981269 ORDER BY `unit` DESC [ RunTime:0.015336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981269 LIMIT 2 [ RunTime:0.007721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981269 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980215 LIMIT 5 [ RunTime:0.020311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980215 ORDER BY `minOrder` ASC [ RunTime:0.033580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980215 ORDER BY `unit` DESC [ RunTime:0.029626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980215 LIMIT 2 [ RunTime:0.023509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980215 ORDER BY `minOrder` ASC [ RunTime:0.032403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980111 LIMIT 5 [ RunTime:0.023017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980111 ORDER BY `minOrder` ASC [ RunTime:0.010595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980111 ORDER BY `unit` DESC [ RunTime:0.027420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980111 LIMIT 2 [ RunTime:0.014112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980111 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18978953 LIMIT 5 [ RunTime:0.026448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978953 ORDER BY `minOrder` ASC [ RunTime:0.021473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18978953 ORDER BY `unit` DESC [ RunTime:0.071587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18978953 LIMIT 2 [ RunTime:0.027817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978953 ORDER BY `minOrder` ASC [ RunTime:0.026096s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023691s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63386954 LIMIT 5 [ RunTime:0.035325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63386954 ORDER BY `minOrder` ASC [ RunTime:0.039505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63386954 ORDER BY `unit` DESC [ RunTime:0.024326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63386954 LIMIT 2 [ RunTime:0.016741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63386954 ORDER BY `minOrder` ASC [ RunTime:0.007286s ]
select * from pdf where partno='10651A' and brandshort='Essentra Components' limit 1 [ RunTime:0.031310s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10651A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.034042s ]
SELECT `id` FROM `stock` WHERE `id` <> 63386954 AND `partno` = '10651A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.059796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047258 [ RunTime:0.019991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60482300 LIMIT 5 [ RunTime:0.040642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60482300 ORDER BY `minOrder` ASC [ RunTime:0.011237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60482300 ORDER BY `unit` DESC [ RunTime:0.005482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60482300 LIMIT 2 [ RunTime:0.030765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60482300 ORDER BY `minOrder` ASC [ RunTime:0.007182s ]
select * from pdf where partno='1065110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.031854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065110000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004600s ]
SELECT `id` FROM `stock` WHERE `id` <> 60482300 AND `partno` = '1065110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19628099 [ RunTime:0.010867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60482302 LIMIT 5 [ RunTime:0.020122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60482302 ORDER BY `minOrder` ASC [ RunTime:0.016449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60482302 ORDER BY `unit` DESC [ RunTime:0.028195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60482302 LIMIT 2 [ RunTime:0.020122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60482302 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
select * from pdf where partno='1065180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007563s ]
SELECT `id` FROM `stock` WHERE `id` <> 60482302 AND `partno` = '1065180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.028332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19628100 [ RunTime:0.023845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484123 LIMIT 5 [ RunTime:0.010771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484123 ORDER BY `minOrder` ASC [ RunTime:0.001012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484123 ORDER BY `unit` DESC [ RunTime:0.008703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484123 LIMIT 2 [ RunTime:0.011838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484123 ORDER BY `minOrder` ASC [ RunTime:0.011599s ]
select * from pdf where partno='1065170000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065170000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005111s ]
SELECT `id` FROM `stock` WHERE `id` <> 60484123 AND `partno` = '1065170000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641364 [ RunTime:0.002265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60630448 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60630448 ORDER BY `minOrder` ASC [ RunTime:0.023699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60630448 ORDER BY `unit` DESC [ RunTime:0.004575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60630448 LIMIT 2 [ RunTime:0.030781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60630448 ORDER BY `minOrder` ASC [ RunTime:0.013164s ]
select * from pdf where partno='1065100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010451s ]
SELECT `id` FROM `stock` WHERE `id` <> 60630448 AND `partno` = '1065100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336842 LIMIT 5 [ RunTime:0.009322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336842 ORDER BY `minOrder` ASC [ RunTime:0.002826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336842 ORDER BY `unit` DESC [ RunTime:0.005311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336842 LIMIT 2 [ RunTime:0.012069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336842 ORDER BY `minOrder` ASC [ RunTime:0.002212s ]
select * from pdf where partno='1065100' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065100' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007494s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336842 AND `partno` = '1065100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190986 [ RunTime:0.007282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336515 LIMIT 5 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336515 ORDER BY `minOrder` ASC [ RunTime:0.001097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336515 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336515 LIMIT 2 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336515 ORDER BY `minOrder` ASC [ RunTime:0.010388s ]
select * from pdf where partno='1065101' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065101' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000623s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336515 AND `partno` = '1065101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190676 [ RunTime:0.010108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60489566 LIMIT 5 [ RunTime:0.010159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60489566 ORDER BY `minOrder` ASC [ RunTime:0.021315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60489566 ORDER BY `unit` DESC [ RunTime:0.013596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60489566 LIMIT 2 [ RunTime:0.024687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60489566 ORDER BY `minOrder` ASC [ RunTime:0.018493s ]
select * from pdf where partno='1065160000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065160000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008259s ]
SELECT `id` FROM `stock` WHERE `id` <> 60489566 AND `partno` = '1065160000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.036617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606136 [ RunTime:0.036188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64808392 LIMIT 5 [ RunTime:0.010725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808392 ORDER BY `minOrder` ASC [ RunTime:0.047529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64808392 ORDER BY `unit` DESC [ RunTime:0.030301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64808392 LIMIT 2 [ RunTime:0.018250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808392 ORDER BY `minOrder` ASC [ RunTime:0.016670s ]
select * from pdf where partno='1065152' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065152' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018541s ]
SELECT `id` FROM `stock` WHERE `id` <> 64808392 AND `partno` = '1065152' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224073 [ RunTime:0.004962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806524 LIMIT 5 [ RunTime:0.010260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806524 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806524 ORDER BY `unit` DESC [ RunTime:0.003176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806524 LIMIT 2 [ RunTime:0.009060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806524 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='1065170' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065170' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006754s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806524 AND `partno` = '1065170' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982765 [ RunTime:0.002692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806199 LIMIT 5 [ RunTime:0.001287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806199 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806199 ORDER BY `unit` DESC [ RunTime:0.001211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806199 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806199 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='1065140' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065140' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000574s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806199 AND `partno` = '1065140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010742 [ RunTime:0.008236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806004 LIMIT 5 [ RunTime:0.003277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806004 ORDER BY `minOrder` ASC [ RunTime:0.005985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806004 ORDER BY `unit` DESC [ RunTime:0.003085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806004 LIMIT 2 [ RunTime:0.031389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806004 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
select * from pdf where partno='1065175' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065175' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024288s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806004 AND `partno` = '1065175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774257 [ RunTime:0.025554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805295 LIMIT 5 [ RunTime:0.013618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805295 ORDER BY `minOrder` ASC [ RunTime:0.014567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805295 ORDER BY `unit` DESC [ RunTime:0.021065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805295 LIMIT 2 [ RunTime:0.015024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805295 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
select * from pdf where partno='1065156' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065156' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018441s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805295 AND `partno` = '1065156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773754 [ RunTime:0.011037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805222 LIMIT 5 [ RunTime:0.008746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805222 ORDER BY `minOrder` ASC [ RunTime:0.007459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805222 ORDER BY `unit` DESC [ RunTime:0.003490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805222 LIMIT 2 [ RunTime:0.002717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805222 ORDER BY `minOrder` ASC [ RunTime:0.012598s ]
select * from pdf where partno='1065161' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065161' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011044s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805222 AND `partno` = '1065161' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981269 [ RunTime:0.002660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803546 LIMIT 5 [ RunTime:0.010583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803546 ORDER BY `minOrder` ASC [ RunTime:0.015342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803546 ORDER BY `unit` DESC [ RunTime:0.012806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803546 LIMIT 2 [ RunTime:0.040321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803546 ORDER BY `minOrder` ASC [ RunTime:0.009435s ]
select * from pdf where partno='1065141' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.048064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065141' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024100s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803546 AND `partno` = '1065141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772829 [ RunTime:0.017709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803537 LIMIT 5 [ RunTime:0.011427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803537 ORDER BY `minOrder` ASC [ RunTime:0.016012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803537 ORDER BY `unit` DESC [ RunTime:0.001938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803537 LIMIT 2 [ RunTime:0.007110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803537 ORDER BY `minOrder` ASC [ RunTime:0.019725s ]
select * from pdf where partno='1065114' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065114' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008131s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803537 AND `partno` = '1065114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223449 [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803404 LIMIT 5 [ RunTime:0.045725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803404 ORDER BY `minOrder` ASC [ RunTime:0.032379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803404 ORDER BY `unit` DESC [ RunTime:0.049537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803404 LIMIT 2 [ RunTime:0.057406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803404 ORDER BY `minOrder` ASC [ RunTime:0.012779s ]
select * from pdf where partno='1065195' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065195' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026772s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803404 AND `partno` = '1065195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772749 [ RunTime:0.013002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802891 LIMIT 5 [ RunTime:0.005815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802891 ORDER BY `minOrder` ASC [ RunTime:0.009609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802891 ORDER BY `unit` DESC [ RunTime:0.020096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802891 LIMIT 2 [ RunTime:0.011807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802891 ORDER BY `minOrder` ASC [ RunTime:0.016496s ]
select * from pdf where partno='1065115' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065115' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021398s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802891 AND `partno` = '1065115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980111 [ RunTime:0.012916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802355 LIMIT 5 [ RunTime:0.043705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802355 ORDER BY `minOrder` ASC [ RunTime:0.014337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802355 ORDER BY `unit` DESC [ RunTime:0.042818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802355 LIMIT 2 [ RunTime:0.081894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802355 ORDER BY `minOrder` ASC [ RunTime:0.007954s ]
select * from pdf where partno='1065160' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065160' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013945s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802355 AND `partno` = '1065160' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.047969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772081 [ RunTime:0.022894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802048 LIMIT 5 [ RunTime:0.043849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802048 ORDER BY `minOrder` ASC [ RunTime:0.020186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802048 ORDER BY `unit` DESC [ RunTime:0.014977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802048 LIMIT 2 [ RunTime:0.022476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802048 ORDER BY `minOrder` ASC [ RunTime:0.002064s ]
select * from pdf where partno='1065194' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065194' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028232s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802048 AND `partno` = '1065194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980215 [ RunTime:0.008734s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013838s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027862s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019322s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051125s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020295s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034244s ]
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 '10651%' OR `brand` LIKE '10651%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005165s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10651%' OR `brand` LIKE '10651%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024729s ]