SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001157s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=7040&search=1' [ RunTime:0.002608s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002305s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000631s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001392s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004985s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001085s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004558s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001648s ]
SELECT * FROM `stock_search` WHERE `partno` = '7040' LIMIT 1 [ RunTime:0.002340s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-20 19:02:16' WHERE `partno` = '7040' [ RunTime:0.001894s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001227s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014471s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067194 LIMIT 5 [ RunTime:0.013487s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067194 ORDER BY `minOrder` ASC [ RunTime:0.010375s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067194 ORDER BY `unit` DESC [ RunTime:0.006183s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067194 LIMIT 2 [ RunTime:0.002878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067194 ORDER BY `minOrder` ASC [ RunTime:0.003625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349588 LIMIT 5 [ RunTime:0.017263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349588 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349588 ORDER BY `unit` DESC [ RunTime:0.009146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349588 LIMIT 2 [ RunTime:0.009766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349588 ORDER BY `minOrder` ASC [ RunTime:0.006883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350493 LIMIT 5 [ RunTime:0.009340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350493 ORDER BY `minOrder` ASC [ RunTime:0.012902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350493 ORDER BY `unit` DESC [ RunTime:0.007415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350493 LIMIT 2 [ RunTime:0.001231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350493 ORDER BY `minOrder` ASC [ RunTime:0.002146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350494 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350494 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350494 ORDER BY `unit` DESC [ RunTime:0.007736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350494 LIMIT 2 [ RunTime:0.007437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350494 ORDER BY `minOrder` ASC [ RunTime:0.008791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350923 LIMIT 5 [ RunTime:0.011076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350923 ORDER BY `minOrder` ASC [ RunTime:0.011960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350923 ORDER BY `unit` DESC [ RunTime:0.014162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350923 LIMIT 2 [ RunTime:0.007659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350923 ORDER BY `minOrder` ASC [ RunTime:0.001972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067517 LIMIT 5 [ RunTime:0.003105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067517 ORDER BY `minOrder` ASC [ RunTime:0.006068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067517 ORDER BY `unit` DESC [ RunTime:0.002475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067517 LIMIT 2 [ RunTime:0.009553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067517 ORDER BY `minOrder` ASC [ RunTime:0.003790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068035 LIMIT 5 [ RunTime:0.004832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068035 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068035 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068035 LIMIT 2 [ RunTime:0.003228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068035 ORDER BY `minOrder` ASC [ RunTime:0.008037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067522 LIMIT 5 [ RunTime:0.003108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067522 ORDER BY `minOrder` ASC [ RunTime:0.011640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067522 ORDER BY `unit` DESC [ RunTime:0.006136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067522 LIMIT 2 [ RunTime:0.003607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067522 ORDER BY `minOrder` ASC [ RunTime:0.009417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067523 LIMIT 5 [ RunTime:0.019498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067523 ORDER BY `minOrder` ASC [ RunTime:0.007695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067523 ORDER BY `unit` DESC [ RunTime:0.004064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067523 LIMIT 2 [ RunTime:0.023063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067523 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350933 LIMIT 5 [ RunTime:0.022904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350933 ORDER BY `minOrder` ASC [ RunTime:0.009123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350933 ORDER BY `unit` DESC [ RunTime:0.006203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350933 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350933 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349611 LIMIT 5 [ RunTime:0.020159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349611 ORDER BY `minOrder` ASC [ RunTime:0.006450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349611 ORDER BY `unit` DESC [ RunTime:0.005545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349611 LIMIT 2 [ RunTime:0.002925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349611 ORDER BY `minOrder` ASC [ RunTime:0.025864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068041 LIMIT 5 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068041 ORDER BY `minOrder` ASC [ RunTime:0.001863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068041 ORDER BY `unit` DESC [ RunTime:0.015135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068041 LIMIT 2 [ RunTime:0.034532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068041 ORDER BY `minOrder` ASC [ RunTime:0.015025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350195 LIMIT 5 [ RunTime:0.038900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350195 ORDER BY `minOrder` ASC [ RunTime:0.026406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350195 ORDER BY `unit` DESC [ RunTime:0.019720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350195 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350195 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13231417 LIMIT 5 [ RunTime:0.004292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13231417 ORDER BY `minOrder` ASC [ RunTime:0.007836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13231417 ORDER BY `unit` DESC [ RunTime:0.011402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13231417 LIMIT 2 [ RunTime:0.012911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13231417 ORDER BY `minOrder` ASC [ RunTime:0.004942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13231404 LIMIT 5 [ RunTime:0.010476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13231404 ORDER BY `minOrder` ASC [ RunTime:0.017935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13231404 ORDER BY `unit` DESC [ RunTime:0.011605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13231404 LIMIT 2 [ RunTime:0.019046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13231404 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11962367 LIMIT 5 [ RunTime:0.004673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11962367 ORDER BY `minOrder` ASC [ RunTime:0.002025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11962367 ORDER BY `unit` DESC [ RunTime:0.011188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11962367 LIMIT 2 [ RunTime:0.006772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11962367 ORDER BY `minOrder` ASC [ RunTime:0.011654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11344091 LIMIT 5 [ RunTime:0.001744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11344091 ORDER BY `minOrder` ASC [ RunTime:0.003024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11344091 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11344091 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11344091 ORDER BY `minOrder` ASC [ RunTime:0.001592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18948194 LIMIT 5 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18948194 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18948194 ORDER BY `unit` DESC [ RunTime:0.003898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18948194 LIMIT 2 [ RunTime:0.005702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18948194 ORDER BY `minOrder` ASC [ RunTime:0.004271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18948193 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18948193 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18948193 ORDER BY `unit` DESC [ RunTime:0.009563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18948193 LIMIT 2 [ RunTime:0.002883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18948193 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18948157 LIMIT 5 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18948157 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18948157 ORDER BY `unit` DESC [ RunTime:0.000275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18948157 LIMIT 2 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18948157 ORDER BY `minOrder` ASC [ RunTime:0.003346s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004996s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562120 LIMIT 5 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562120 ORDER BY `minOrder` ASC [ RunTime:0.003432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562120 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562120 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562120 ORDER BY `minOrder` ASC [ RunTime:0.001912s ]
select * from pdf where partno='70406SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001822s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70406SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000544s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562120 AND `partno` = '70406SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350933 [ RunTime:0.001160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562124 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562124 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562124 ORDER BY `unit` DESC [ RunTime:0.002197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562124 LIMIT 2 [ RunTime:0.004241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562124 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='70404SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70404SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004259s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562124 AND `partno` = '70404SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350923 [ RunTime:0.015288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560119 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560119 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560119 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560119 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560119 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
select * from pdf where partno='70408CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70408CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002894s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560119 AND `partno` = '70408CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349588 [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562126 LIMIT 5 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562126 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562126 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562126 LIMIT 2 [ RunTime:0.004207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562126 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
select * from pdf where partno='70405SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70405SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002741s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562126 AND `partno` = '70405SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.010880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068035 [ RunTime:0.006340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561499 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561499 ORDER BY `minOrder` ASC [ RunTime:0.001187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561499 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561499 LIMIT 2 [ RunTime:0.004220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561499 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='70409SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70409SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000872s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561499 AND `partno` = '70409SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560196 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560196 ORDER BY `minOrder` ASC [ RunTime:0.001603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560196 ORDER BY `unit` DESC [ RunTime:0.002128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560196 LIMIT 2 [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560196 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
select * from pdf where partno='70403CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70403CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002238s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560196 AND `partno` = '70403CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560957 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560957 ORDER BY `minOrder` ASC [ RunTime:0.001038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560957 ORDER BY `unit` DESC [ RunTime:0.004790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560957 LIMIT 2 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560957 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='70401CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70401CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000805s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560957 AND `partno` = '70401CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350195 [ RunTime:0.001311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560958 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560958 ORDER BY `minOrder` ASC [ RunTime:0.015545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560958 ORDER BY `unit` DESC [ RunTime:0.001010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560958 LIMIT 2 [ RunTime:0.002221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560958 ORDER BY `minOrder` ASC [ RunTime:0.005257s ]
select * from pdf where partno='70406CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70406CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009082s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560958 AND `partno` = '70406CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067523 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562145 LIMIT 5 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562145 ORDER BY `minOrder` ASC [ RunTime:0.017022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562145 ORDER BY `unit` DESC [ RunTime:0.000699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562145 LIMIT 2 [ RunTime:0.001120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562145 ORDER BY `minOrder` ASC [ RunTime:0.002350s ]
select * from pdf where partno='70400SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.010233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70400SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005301s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562145 AND `partno` = '70400SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068041 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561544 LIMIT 5 [ RunTime:0.003139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561544 ORDER BY `minOrder` ASC [ RunTime:0.008045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561544 ORDER BY `unit` DESC [ RunTime:0.008549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561544 LIMIT 2 [ RunTime:0.018377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561544 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='70408SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70408SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006457s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561544 AND `partno` = '70408SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350493 [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560987 LIMIT 5 [ RunTime:0.001754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560987 ORDER BY `minOrder` ASC [ RunTime:0.018393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560987 ORDER BY `unit` DESC [ RunTime:0.001544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560987 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560987 ORDER BY `minOrder` ASC [ RunTime:0.001457s ]
select * from pdf where partno='70404CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70404CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002031s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560987 AND `partno` = '70404CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067522 [ RunTime:0.006975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560165 LIMIT 5 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560165 ORDER BY `minOrder` ASC [ RunTime:0.004343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560165 ORDER BY `unit` DESC [ RunTime:0.003085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560165 LIMIT 2 [ RunTime:0.003313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560165 ORDER BY `minOrder` ASC [ RunTime:0.001817s ]
select * from pdf where partno='70407CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70407CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003797s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560165 AND `partno` = '70407CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067194 [ RunTime:0.007150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562169 LIMIT 5 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562169 ORDER BY `minOrder` ASC [ RunTime:0.013765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562169 ORDER BY `unit` DESC [ RunTime:0.001175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562169 LIMIT 2 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562169 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='70401SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70401SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002088s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562169 AND `partno` = '70401SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560177 LIMIT 5 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560177 ORDER BY `minOrder` ASC [ RunTime:0.001775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560177 ORDER BY `unit` DESC [ RunTime:0.000737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560177 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560177 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='70409CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70409CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003648s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560177 AND `partno` = '70409CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349611 [ RunTime:0.000745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565841 LIMIT 5 [ RunTime:0.002458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565841 ORDER BY `minOrder` ASC [ RunTime:0.005663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565841 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565841 LIMIT 2 [ RunTime:0.001994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565841 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='70400CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70400CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008572s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565841 AND `partno` = '70400CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067517 [ RunTime:0.008876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565842 LIMIT 5 [ RunTime:0.005924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565842 ORDER BY `minOrder` ASC [ RunTime:0.008466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565842 ORDER BY `unit` DESC [ RunTime:0.002962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565842 LIMIT 2 [ RunTime:0.005191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565842 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
select * from pdf where partno='70405CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70405CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000913s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565842 AND `partno` = '70405CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565942 LIMIT 5 [ RunTime:0.003080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565942 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565942 ORDER BY `unit` DESC [ RunTime:0.004368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565942 LIMIT 2 [ RunTime:0.005675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565942 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
select * from pdf where partno='70407SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70407SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001776s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565942 AND `partno` = '70407SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350494 [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64537160 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64537160 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64537160 ORDER BY `unit` DESC [ RunTime:0.002620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64537160 LIMIT 2 [ RunTime:0.010022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64537160 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='70402' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70402' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000961s ]
SELECT `id` FROM `stock` WHERE `id` <> 64537160 AND `partno` = '70402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421536 [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64536515 LIMIT 5 [ RunTime:0.002274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536515 ORDER BY `minOrder` ASC [ RunTime:0.002941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64536515 ORDER BY `unit` DESC [ RunTime:0.005425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64536515 LIMIT 2 [ RunTime:0.019408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536515 ORDER BY `minOrder` ASC [ RunTime:0.002021s ]
select * from pdf where partno='70409' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70409' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003642s ]
SELECT `id` FROM `stock` WHERE `id` <> 64536515 AND `partno` = '70409' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.015947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550889 [ RunTime:0.005382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64536511 LIMIT 5 [ RunTime:0.003929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536511 ORDER BY `minOrder` ASC [ RunTime:0.012451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64536511 ORDER BY `unit` DESC [ RunTime:0.005226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64536511 LIMIT 2 [ RunTime:0.014083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536511 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
select * from pdf where partno='70406' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70406' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013234s ]
SELECT `id` FROM `stock` WHERE `id` <> 64536511 AND `partno` = '70406' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421211 [ RunTime:0.002059s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007476s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009666s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005548s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019146s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001492s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001834s ]
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 '7040%' OR `brand` LIKE '7040%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005397s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7040%' OR `brand` LIKE '7040%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007733s ]