SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001542s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015172s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350086 LIMIT 5 [ RunTime:0.016796s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350086 ORDER BY `minOrder` ASC [ RunTime:0.001664s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350086 ORDER BY `unit` DESC [ RunTime:0.002300s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350086 LIMIT 2 [ RunTime:0.013649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350086 ORDER BY `minOrder` ASC [ RunTime:0.033378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034030 LIMIT 5 [ RunTime:0.007033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034030 ORDER BY `minOrder` ASC [ RunTime:0.049649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034030 ORDER BY `unit` DESC [ RunTime:0.032858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034030 LIMIT 2 [ RunTime:0.027279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034030 ORDER BY `minOrder` ASC [ RunTime:0.027260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982554 LIMIT 5 [ RunTime:0.061510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982554 ORDER BY `minOrder` ASC [ RunTime:0.038509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982554 ORDER BY `unit` DESC [ RunTime:0.054565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982554 LIMIT 2 [ RunTime:0.021554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982554 ORDER BY `minOrder` ASC [ RunTime:0.008576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980620 LIMIT 5 [ RunTime:0.066217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980620 ORDER BY `minOrder` ASC [ RunTime:0.039377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980620 ORDER BY `unit` DESC [ RunTime:0.028103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980620 LIMIT 2 [ RunTime:0.064291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980620 ORDER BY `minOrder` ASC [ RunTime:0.019005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979129 LIMIT 5 [ RunTime:0.101607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979129 ORDER BY `minOrder` ASC [ RunTime:0.042658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979129 ORDER BY `unit` DESC [ RunTime:0.053526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979129 LIMIT 2 [ RunTime:0.022228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979129 ORDER BY `minOrder` ASC [ RunTime:0.028947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18840566 LIMIT 5 [ RunTime:0.040437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18840566 ORDER BY `minOrder` ASC [ RunTime:0.085392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18840566 ORDER BY `unit` DESC [ RunTime:0.025364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18840566 LIMIT 2 [ RunTime:0.053490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18840566 ORDER BY `minOrder` ASC [ RunTime:0.016355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793334 LIMIT 5 [ RunTime:0.023351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793334 ORDER BY `minOrder` ASC [ RunTime:0.036932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793334 ORDER BY `unit` DESC [ RunTime:0.015261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793334 LIMIT 2 [ RunTime:0.022370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793334 ORDER BY `minOrder` ASC [ RunTime:0.017031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793333 LIMIT 5 [ RunTime:0.024023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793333 ORDER BY `minOrder` ASC [ RunTime:0.006087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793333 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793333 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793333 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792971 LIMIT 5 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792971 ORDER BY `minOrder` ASC [ RunTime:0.014769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792971 ORDER BY `unit` DESC [ RunTime:0.003200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792971 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792971 ORDER BY `minOrder` ASC [ RunTime:0.016646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792942 LIMIT 5 [ RunTime:0.016619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792942 ORDER BY `minOrder` ASC [ RunTime:0.004468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792942 ORDER BY `unit` DESC [ RunTime:0.000997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792942 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792942 ORDER BY `minOrder` ASC [ RunTime:0.004055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792941 LIMIT 5 [ RunTime:0.003208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792941 ORDER BY `minOrder` ASC [ RunTime:0.004900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792941 ORDER BY `unit` DESC [ RunTime:0.020904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792941 LIMIT 2 [ RunTime:0.001328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792941 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792940 LIMIT 5 [ RunTime:0.003902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792940 ORDER BY `minOrder` ASC [ RunTime:0.004234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792940 ORDER BY `unit` DESC [ RunTime:0.001803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792940 LIMIT 2 [ RunTime:0.007915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792940 ORDER BY `minOrder` ASC [ RunTime:0.003231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792939 LIMIT 5 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792939 ORDER BY `minOrder` ASC [ RunTime:0.008265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792939 ORDER BY `unit` DESC [ RunTime:0.001343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792939 LIMIT 2 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792939 ORDER BY `minOrder` ASC [ RunTime:0.006209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792831 LIMIT 5 [ RunTime:0.006041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792831 ORDER BY `minOrder` ASC [ RunTime:0.003261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792831 ORDER BY `unit` DESC [ RunTime:0.011821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792831 LIMIT 2 [ RunTime:0.001792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792831 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792830 LIMIT 5 [ RunTime:0.003631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792830 ORDER BY `minOrder` ASC [ RunTime:0.015262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792830 ORDER BY `unit` DESC [ RunTime:0.000783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792830 LIMIT 2 [ RunTime:0.007845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792830 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792829 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792829 ORDER BY `minOrder` ASC [ RunTime:0.004270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792829 ORDER BY `unit` DESC [ RunTime:0.008379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792829 LIMIT 2 [ RunTime:0.003081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792829 ORDER BY `minOrder` ASC [ RunTime:0.002067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792828 LIMIT 5 [ RunTime:0.001339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792828 ORDER BY `minOrder` ASC [ RunTime:0.003177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792828 ORDER BY `unit` DESC [ RunTime:0.005191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792828 LIMIT 2 [ RunTime:0.008620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792828 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775608 LIMIT 5 [ RunTime:0.009464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775608 ORDER BY `minOrder` ASC [ RunTime:0.006645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775608 ORDER BY `unit` DESC [ RunTime:0.008929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775608 LIMIT 2 [ RunTime:0.004122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775608 ORDER BY `minOrder` ASC [ RunTime:0.006704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775427 LIMIT 5 [ RunTime:0.007984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775427 ORDER BY `minOrder` ASC [ RunTime:0.003219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775427 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775427 LIMIT 2 [ RunTime:0.002076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775427 ORDER BY `minOrder` ASC [ RunTime:0.006208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775075 LIMIT 5 [ RunTime:0.023138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775075 ORDER BY `minOrder` ASC [ RunTime:0.009654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775075 ORDER BY `unit` DESC [ RunTime:0.008501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775075 LIMIT 2 [ RunTime:0.012920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775075 ORDER BY `minOrder` ASC [ RunTime:0.008165s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004123s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560813 LIMIT 5 [ RunTime:0.016297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560813 ORDER BY `minOrder` ASC [ RunTime:0.043398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560813 ORDER BY `unit` DESC [ RunTime:0.001123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560813 LIMIT 2 [ RunTime:0.002674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560813 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
select * from pdf where partno='10682CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001251s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10682CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005332s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560813 AND `partno` = '10682CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.014276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350086 [ RunTime:0.002259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786448 LIMIT 5 [ RunTime:0.010346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786448 ORDER BY `minOrder` ASC [ RunTime:0.011809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786448 ORDER BY `unit` DESC [ RunTime:0.002443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786448 LIMIT 2 [ RunTime:0.021633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786448 ORDER BY `minOrder` ASC [ RunTime:0.012126s ]
select * from pdf where partno='1068264' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068264' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002855s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786448 AND `partno` = '1068264' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227654 [ RunTime:0.002052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786438 LIMIT 5 [ RunTime:0.002836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786438 ORDER BY `minOrder` ASC [ RunTime:0.008057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786438 ORDER BY `unit` DESC [ RunTime:0.036605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786438 LIMIT 2 [ RunTime:0.001602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786438 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='1068259' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068259' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005571s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786438 AND `partno` = '1068259' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792940 [ RunTime:0.004829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786431 LIMIT 5 [ RunTime:0.001697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786431 ORDER BY `minOrder` ASC [ RunTime:0.009953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786431 ORDER BY `unit` DESC [ RunTime:0.029330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786431 LIMIT 2 [ RunTime:0.017284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786431 ORDER BY `minOrder` ASC [ RunTime:0.023930s ]
select * from pdf where partno='1068257' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068257' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012664s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786431 AND `partno` = '1068257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.049229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792831 [ RunTime:0.019310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786430 LIMIT 5 [ RunTime:0.031890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786430 ORDER BY `minOrder` ASC [ RunTime:0.021419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786430 ORDER BY `unit` DESC [ RunTime:0.073036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786430 LIMIT 2 [ RunTime:0.025901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786430 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
select * from pdf where partno='1068255' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068255' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021837s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786430 AND `partno` = '1068255' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792829 [ RunTime:0.024645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64808256 LIMIT 5 [ RunTime:0.016298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808256 ORDER BY `minOrder` ASC [ RunTime:0.012216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64808256 ORDER BY `unit` DESC [ RunTime:0.008917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64808256 LIMIT 2 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808256 ORDER BY `minOrder` ASC [ RunTime:0.002943s ]
select * from pdf where partno='1068200' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068200' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025395s ]
SELECT `id` FROM `stock` WHERE `id` <> 64808256 AND `partno` = '1068200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775608 [ RunTime:0.024031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807880 LIMIT 5 [ RunTime:0.041510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807880 ORDER BY `minOrder` ASC [ RunTime:0.011142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807880 ORDER BY `unit` DESC [ RunTime:0.012619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807880 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807880 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
select * from pdf where partno='1068209' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068209' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003122s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807880 AND `partno` = '1068209' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775427 [ RunTime:0.009317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807540 LIMIT 5 [ RunTime:0.015842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807540 ORDER BY `minOrder` ASC [ RunTime:0.002230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807540 ORDER BY `unit` DESC [ RunTime:0.002371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807540 LIMIT 2 [ RunTime:0.008183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807540 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
select * from pdf where partno='1068203' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068203' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005746s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807540 AND `partno` = '1068203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775075 [ RunTime:0.000695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806152 LIMIT 5 [ RunTime:0.003985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806152 ORDER BY `minOrder` ASC [ RunTime:0.010099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806152 ORDER BY `unit` DESC [ RunTime:0.006493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806152 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806152 ORDER BY `minOrder` ASC [ RunTime:0.001042s ]
select * from pdf where partno='1068205' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068205' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006967s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806152 AND `partno` = '1068205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774272 [ RunTime:0.004081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805296 LIMIT 5 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805296 ORDER BY `minOrder` ASC [ RunTime:0.001337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805296 ORDER BY `unit` DESC [ RunTime:0.004686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805296 LIMIT 2 [ RunTime:0.004499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805296 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
select * from pdf where partno='1068212' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068212' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002484s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805296 AND `partno` = '1068212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774254 [ RunTime:0.000737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803792 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803792 ORDER BY `minOrder` ASC [ RunTime:0.008724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803792 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803792 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803792 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='1068238' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068238' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003425s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803792 AND `partno` = '1068238' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223480 [ RunTime:0.003221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803018 LIMIT 5 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803018 ORDER BY `minOrder` ASC [ RunTime:0.001433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803018 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803018 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803018 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='1068287' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068287' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005046s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803018 AND `partno` = '1068287' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772430 [ RunTime:0.009417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801723 LIMIT 5 [ RunTime:0.005130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801723 ORDER BY `minOrder` ASC [ RunTime:0.002879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801723 ORDER BY `unit` DESC [ RunTime:0.001113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801723 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801723 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='1068206' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068206' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000878s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801723 AND `partno` = '1068206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223199 [ RunTime:0.002174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800439 LIMIT 5 [ RunTime:0.006205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800439 ORDER BY `minOrder` ASC [ RunTime:0.016350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800439 ORDER BY `unit` DESC [ RunTime:0.009782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800439 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800439 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='1068202' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068202' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010075s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800439 AND `partno` = '1068202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770794 [ RunTime:0.001533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788228 LIMIT 5 [ RunTime:0.008084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788228 ORDER BY `minOrder` ASC [ RunTime:0.005109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788228 ORDER BY `unit` DESC [ RunTime:0.007922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788228 LIMIT 2 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788228 ORDER BY `minOrder` ASC [ RunTime:0.002218s ]
select * from pdf where partno='1068267' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068267' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000782s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788228 AND `partno` = '1068267' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793334 [ RunTime:0.005494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788227 LIMIT 5 [ RunTime:0.011801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788227 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788227 ORDER BY `unit` DESC [ RunTime:0.006704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788227 LIMIT 2 [ RunTime:0.007552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788227 ORDER BY `minOrder` ASC [ RunTime:0.007906s ]
select * from pdf where partno='1068266' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068266' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003554s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788227 AND `partno` = '1068266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227655 [ RunTime:0.003247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788226 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788226 ORDER BY `minOrder` ASC [ RunTime:0.008946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788226 ORDER BY `unit` DESC [ RunTime:0.003191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788226 LIMIT 2 [ RunTime:0.009695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788226 ORDER BY `minOrder` ASC [ RunTime:0.003873s ]
select * from pdf where partno='1068263' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068263' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006057s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788226 AND `partno` = '1068263' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793333 [ RunTime:0.006228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787803 LIMIT 5 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787803 ORDER BY `minOrder` ASC [ RunTime:0.005979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787803 ORDER BY `unit` DESC [ RunTime:0.006296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787803 LIMIT 2 [ RunTime:0.015363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787803 ORDER BY `minOrder` ASC [ RunTime:0.009266s ]
select * from pdf where partno='1068253' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068253' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001694s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787803 AND `partno` = '1068253' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227586 [ RunTime:0.006081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787802 LIMIT 5 [ RunTime:0.004806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787802 ORDER BY `minOrder` ASC [ RunTime:0.009876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787802 ORDER BY `unit` DESC [ RunTime:0.005277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787802 LIMIT 2 [ RunTime:0.004243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787802 ORDER BY `minOrder` ASC [ RunTime:0.007508s ]
select * from pdf where partno='1068252' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068252' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004762s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787802 AND `partno` = '1068252' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227585 [ RunTime:0.008069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64787801 LIMIT 5 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787801 ORDER BY `minOrder` ASC [ RunTime:0.007080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64787801 ORDER BY `unit` DESC [ RunTime:0.007233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64787801 LIMIT 2 [ RunTime:0.003139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64787801 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='1068251' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1068251' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002039s ]
SELECT `id` FROM `stock` WHERE `id` <> 64787801 AND `partno` = '1068251' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15227584 [ RunTime:0.004096s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008292s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032628s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014989s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010666s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017804s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040043s ]
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 '10682%' OR `brand` LIKE '10682%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027552s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10682%' OR `brand` LIKE '10682%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.050595s ]