SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002140s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=2797&search=1' [ RunTime:0.005889s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002294s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003960s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002663s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.001737s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002026s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000859s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002043s ]
SELECT * FROM `stock_search` WHERE `partno` = '2797' LIMIT 1 [ RunTime:0.007285s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 14:49:44' WHERE `partno` = '2797' [ RunTime:0.019987s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002206s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024869s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351420 LIMIT 5 [ RunTime:0.015459s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351420 ORDER BY `minOrder` ASC [ RunTime:0.006742s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351420 ORDER BY `unit` DESC [ RunTime:0.001713s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351420 LIMIT 2 [ RunTime:0.012303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351420 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12158810 LIMIT 5 [ RunTime:0.016984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12158810 ORDER BY `minOrder` ASC [ RunTime:0.012006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12158810 ORDER BY `unit` DESC [ RunTime:0.020353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12158810 LIMIT 2 [ RunTime:0.017013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12158810 ORDER BY `minOrder` ASC [ RunTime:0.014172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073749 LIMIT 5 [ RunTime:0.018780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073749 ORDER BY `minOrder` ASC [ RunTime:0.006872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073749 ORDER BY `unit` DESC [ RunTime:0.022897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073749 LIMIT 2 [ RunTime:0.023175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073749 ORDER BY `minOrder` ASC [ RunTime:0.003402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651289 LIMIT 5 [ RunTime:0.031483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651289 ORDER BY `minOrder` ASC [ RunTime:0.035396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651289 ORDER BY `unit` DESC [ RunTime:0.016152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651289 LIMIT 2 [ RunTime:0.040874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651289 ORDER BY `minOrder` ASC [ RunTime:0.030760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650177 LIMIT 5 [ RunTime:0.041785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650177 ORDER BY `minOrder` ASC [ RunTime:0.041362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650177 ORDER BY `unit` DESC [ RunTime:0.013463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650177 LIMIT 2 [ RunTime:0.012938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650177 ORDER BY `minOrder` ASC [ RunTime:0.008231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645255 LIMIT 5 [ RunTime:0.014959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645255 ORDER BY `minOrder` ASC [ RunTime:0.016809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19645255 ORDER BY `unit` DESC [ RunTime:0.001176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19645255 LIMIT 2 [ RunTime:0.013675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645255 ORDER BY `minOrder` ASC [ RunTime:0.009980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642890 LIMIT 5 [ RunTime:0.006506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642890 ORDER BY `minOrder` ASC [ RunTime:0.010939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642890 ORDER BY `unit` DESC [ RunTime:0.010900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642890 LIMIT 2 [ RunTime:0.024133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642890 ORDER BY `minOrder` ASC [ RunTime:0.003948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957628 LIMIT 5 [ RunTime:0.006437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957628 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18957628 ORDER BY `unit` DESC [ RunTime:0.020196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18957628 LIMIT 2 [ RunTime:0.031479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957628 ORDER BY `minOrder` ASC [ RunTime:0.006649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934635 LIMIT 5 [ RunTime:0.018240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934635 ORDER BY `minOrder` ASC [ RunTime:0.005094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18934635 ORDER BY `unit` DESC [ RunTime:0.053271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18934635 LIMIT 2 [ RunTime:0.026177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934635 ORDER BY `minOrder` ASC [ RunTime:0.022487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412690 LIMIT 5 [ RunTime:0.029934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412690 ORDER BY `minOrder` ASC [ RunTime:0.020327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412690 ORDER BY `unit` DESC [ RunTime:0.022039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412690 LIMIT 2 [ RunTime:0.023021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412690 ORDER BY `minOrder` ASC [ RunTime:0.032263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412680 LIMIT 5 [ RunTime:0.043014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412680 ORDER BY `minOrder` ASC [ RunTime:0.018436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412680 ORDER BY `unit` DESC [ RunTime:0.053740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412680 LIMIT 2 [ RunTime:0.024584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412680 ORDER BY `minOrder` ASC [ RunTime:0.014400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412649 LIMIT 5 [ RunTime:0.027441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412649 ORDER BY `minOrder` ASC [ RunTime:0.023159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412649 ORDER BY `unit` DESC [ RunTime:0.020820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412649 LIMIT 2 [ RunTime:0.029071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412649 ORDER BY `minOrder` ASC [ RunTime:0.019500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451161 LIMIT 5 [ RunTime:0.005017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451161 ORDER BY `minOrder` ASC [ RunTime:0.011427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451161 ORDER BY `unit` DESC [ RunTime:0.005793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451161 LIMIT 2 [ RunTime:0.043163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451161 ORDER BY `minOrder` ASC [ RunTime:0.010309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261333 LIMIT 5 [ RunTime:0.031818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261333 ORDER BY `minOrder` ASC [ RunTime:0.016137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15261333 ORDER BY `unit` DESC [ RunTime:0.027062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15261333 LIMIT 2 [ RunTime:0.020950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261333 ORDER BY `minOrder` ASC [ RunTime:0.006779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260959 LIMIT 5 [ RunTime:0.027932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260959 ORDER BY `minOrder` ASC [ RunTime:0.028552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15260959 ORDER BY `unit` DESC [ RunTime:0.030151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15260959 LIMIT 2 [ RunTime:0.024833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260959 ORDER BY `minOrder` ASC [ RunTime:0.006118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219413 LIMIT 5 [ RunTime:0.011171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219413 ORDER BY `minOrder` ASC [ RunTime:0.026836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219413 ORDER BY `unit` DESC [ RunTime:0.034549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219413 LIMIT 2 [ RunTime:0.034789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219413 ORDER BY `minOrder` ASC [ RunTime:0.014768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387217 LIMIT 5 [ RunTime:0.017834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387217 ORDER BY `minOrder` ASC [ RunTime:0.031419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387217 ORDER BY `unit` DESC [ RunTime:0.006265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387217 LIMIT 2 [ RunTime:0.038709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387217 ORDER BY `minOrder` ASC [ RunTime:0.050453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381594 LIMIT 5 [ RunTime:0.029829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381594 ORDER BY `minOrder` ASC [ RunTime:0.012317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381594 ORDER BY `unit` DESC [ RunTime:0.009406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381594 LIMIT 2 [ RunTime:0.011209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381594 ORDER BY `minOrder` ASC [ RunTime:0.020775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380714 LIMIT 5 [ RunTime:0.007180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380714 ORDER BY `minOrder` ASC [ RunTime:0.024561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380714 ORDER BY `unit` DESC [ RunTime:0.028106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380714 LIMIT 2 [ RunTime:0.018727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380714 ORDER BY `minOrder` ASC [ RunTime:0.036608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513714 LIMIT 5 [ RunTime:0.022255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513714 ORDER BY `minOrder` ASC [ RunTime:0.033664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513714 ORDER BY `unit` DESC [ RunTime:0.011925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513714 LIMIT 2 [ RunTime:0.040409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513714 ORDER BY `minOrder` ASC [ RunTime:0.016890s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027462s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57743203 LIMIT 5 [ RunTime:0.015825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57743203 ORDER BY `minOrder` ASC [ RunTime:0.020526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57743203 ORDER BY `unit` DESC [ RunTime:0.029017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57743203 LIMIT 2 [ RunTime:0.027159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57743203 ORDER BY `minOrder` ASC [ RunTime:0.017587s ]
select * from pdf where partno='2797CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.018068s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.025361s ]
SELECT `id` FROM `stock` WHERE `id` <> 57743203 AND `partno` = '2797CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351420 [ RunTime:0.008411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51674510 LIMIT 5 [ RunTime:0.018466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674510 ORDER BY `minOrder` ASC [ RunTime:0.009587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51674510 ORDER BY `unit` DESC [ RunTime:0.008565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51674510 LIMIT 2 [ RunTime:0.015834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674510 ORDER BY `minOrder` ASC [ RunTime:0.007554s ]
select * from pdf where partno='27977-16T50' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.013220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27977-16T50' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.023116s ]
SELECT `id` FROM `stock` WHERE `id` <> 51674510 AND `partno` = '27977-16T50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.016239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51674847 LIMIT 5 [ RunTime:0.008376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674847 ORDER BY `minOrder` ASC [ RunTime:0.016062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51674847 ORDER BY `unit` DESC [ RunTime:0.032667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51674847 LIMIT 2 [ RunTime:0.013332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674847 ORDER BY `minOrder` ASC [ RunTime:0.005892s ]
select * from pdf where partno='27977-12T8' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.006469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27977-12T8' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.033657s ]
SELECT `id` FROM `stock` WHERE `id` <> 51674847 AND `partno` = '27977-12T8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.039488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12158810 [ RunTime:0.013950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57610212 LIMIT 5 [ RunTime:0.022236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57610212 ORDER BY `minOrder` ASC [ RunTime:0.023711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57610212 ORDER BY `unit` DESC [ RunTime:0.036962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57610212 LIMIT 2 [ RunTime:0.054798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57610212 ORDER BY `minOrder` ASC [ RunTime:0.012576s ]
select * from pdf where partno='2797' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.029372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.029648s ]
SELECT `id` FROM `stock` WHERE `id` <> 57610212 AND `partno` = '2797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.018745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13365385 [ RunTime:0.014810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57609587 LIMIT 5 [ RunTime:0.014234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57609587 ORDER BY `minOrder` ASC [ RunTime:0.008249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57609587 ORDER BY `unit` DESC [ RunTime:0.018569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57609587 LIMIT 2 [ RunTime:0.002969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57609587 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
select * from pdf where partno='27971' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.009814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27971' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.035253s ]
SELECT `id` FROM `stock` WHERE `id` <> 57609587 AND `partno` = '27971' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.013262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373693 [ RunTime:0.081524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56601771 LIMIT 5 [ RunTime:0.029652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56601771 ORDER BY `minOrder` ASC [ RunTime:0.063928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56601771 ORDER BY `unit` DESC [ RunTime:0.032350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56601771 LIMIT 2 [ RunTime:0.054042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56601771 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
select * from pdf where partno='2797' and brandshort='80/20, LLC' limit 1 [ RunTime:0.026749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.024789s ]
SELECT `id` FROM `stock` WHERE `id` <> 56601771 AND `partno` = '2797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.022399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56577079 LIMIT 5 [ RunTime:0.015623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577079 ORDER BY `minOrder` ASC [ RunTime:0.031146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56577079 ORDER BY `unit` DESC [ RunTime:0.006539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56577079 LIMIT 2 [ RunTime:0.003030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56577079 ORDER BY `minOrder` ASC [ RunTime:0.003425s ]
select * from pdf where partno='2797' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.025025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.006750s ]
SELECT `id` FROM `stock` WHERE `id` <> 56577079 AND `partno` = '2797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.024502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53716133 LIMIT 5 [ RunTime:0.023216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53716133 ORDER BY `minOrder` ASC [ RunTime:0.011770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53716133 ORDER BY `unit` DESC [ RunTime:0.028333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53716133 LIMIT 2 [ RunTime:0.041850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53716133 ORDER BY `minOrder` ASC [ RunTime:0.008748s ]
select * from pdf where partno='2797370000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797370000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014654s ]
SELECT `id` FROM `stock` WHERE `id` <> 53716133 AND `partno` = '2797370000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.038298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651289 [ RunTime:0.017298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53714557 LIMIT 5 [ RunTime:0.006546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53714557 ORDER BY `minOrder` ASC [ RunTime:0.008821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53714557 ORDER BY `unit` DESC [ RunTime:0.008057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53714557 LIMIT 2 [ RunTime:0.001217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53714557 ORDER BY `minOrder` ASC [ RunTime:0.002168s ]
select * from pdf where partno='2797360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797360000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022488s ]
SELECT `id` FROM `stock` WHERE `id` <> 53714557 AND `partno` = '2797360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650177 [ RunTime:0.017463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53709033 LIMIT 5 [ RunTime:0.026374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709033 ORDER BY `minOrder` ASC [ RunTime:0.004683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53709033 ORDER BY `unit` DESC [ RunTime:0.018510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53709033 LIMIT 2 [ RunTime:0.019272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709033 ORDER BY `minOrder` ASC [ RunTime:0.015304s ]
select * from pdf where partno='2797350000' and brandshort='Weidmüller' limit 1 [ RunTime:0.025048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797350000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012268s ]
SELECT `id` FROM `stock` WHERE `id` <> 53709033 AND `partno` = '2797350000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451161 [ RunTime:0.012410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53706742 LIMIT 5 [ RunTime:0.015141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53706742 ORDER BY `minOrder` ASC [ RunTime:0.018310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53706742 ORDER BY `unit` DESC [ RunTime:0.017002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53706742 LIMIT 2 [ RunTime:0.035671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53706742 ORDER BY `minOrder` ASC [ RunTime:0.004201s ]
select * from pdf where partno='2797340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.021454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018226s ]
SELECT `id` FROM `stock` WHERE `id` <> 53706742 AND `partno` = '2797340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.019196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645255 [ RunTime:0.012863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53702466 LIMIT 5 [ RunTime:0.011733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53702466 ORDER BY `minOrder` ASC [ RunTime:0.018209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53702466 ORDER BY `unit` DESC [ RunTime:0.017687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53702466 LIMIT 2 [ RunTime:0.008564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53702466 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
select * from pdf where partno='2797300000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797300000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024719s ]
SELECT `id` FROM `stock` WHERE `id` <> 53702466 AND `partno` = '2797300000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642890 [ RunTime:0.023310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53606010 LIMIT 5 [ RunTime:0.031520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53606010 ORDER BY `minOrder` ASC [ RunTime:0.004939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53606010 ORDER BY `unit` DESC [ RunTime:0.019581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53606010 LIMIT 2 [ RunTime:0.004762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53606010 ORDER BY `minOrder` ASC [ RunTime:0.012997s ]
select * from pdf where partno='2797020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.026323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.042928s ]
SELECT `id` FROM `stock` WHERE `id` <> 53606010 AND `partno` = '2797020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53602280 LIMIT 5 [ RunTime:0.035568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602280 ORDER BY `minOrder` ASC [ RunTime:0.019032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53602280 ORDER BY `unit` DESC [ RunTime:0.027617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53602280 LIMIT 2 [ RunTime:0.014494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602280 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='2797670000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797670000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009418s ]
SELECT `id` FROM `stock` WHERE `id` <> 53602280 AND `partno` = '2797670000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073749 [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53589920 LIMIT 5 [ RunTime:0.007615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589920 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53589920 ORDER BY `unit` DESC [ RunTime:0.011626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53589920 LIMIT 2 [ RunTime:0.015100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589920 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='2797.0/100' and brandshort='Altech Corporation' limit 1 [ RunTime:0.001656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797.0/100' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.016418s ]
SELECT `id` FROM `stock` WHERE `id` <> 53589920 AND `partno` = '2797.0/100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.021360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53589901 LIMIT 5 [ RunTime:0.004714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589901 ORDER BY `minOrder` ASC [ RunTime:0.016050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53589901 ORDER BY `unit` DESC [ RunTime:0.012668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53589901 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589901 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='2797.0' and brandshort='Altech Corporation' limit 1 [ RunTime:0.001484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797.0' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.011435s ]
SELECT `id` FROM `stock` WHERE `id` <> 53589901 AND `partno` = '2797.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.026464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53589801 LIMIT 5 [ RunTime:0.002449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589801 ORDER BY `minOrder` ASC [ RunTime:0.023386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53589801 ORDER BY `unit` DESC [ RunTime:0.007174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53589801 LIMIT 2 [ RunTime:0.002440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53589801 ORDER BY `minOrder` ASC [ RunTime:0.009375s ]
select * from pdf where partno='2797.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.008016s ]
SELECT `id` FROM `stock` WHERE `id` <> 53589801 AND `partno` = '2797.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.029310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51683543 LIMIT 5 [ RunTime:0.016251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683543 ORDER BY `minOrder` ASC [ RunTime:0.017891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51683543 ORDER BY `unit` DESC [ RunTime:0.006155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51683543 LIMIT 2 [ RunTime:0.003844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683543 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='2797200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001354s ]
SELECT `id` FROM `stock` WHERE `id` <> 51683543 AND `partno` = '2797200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194460 [ RunTime:0.004995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51683542 LIMIT 5 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683542 ORDER BY `minOrder` ASC [ RunTime:0.006661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51683542 ORDER BY `unit` DESC [ RunTime:0.016797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51683542 LIMIT 2 [ RunTime:0.001723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683542 ORDER BY `minOrder` ASC [ RunTime:0.003819s ]
select * from pdf where partno='2797190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2797190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002502s ]
SELECT `id` FROM `stock` WHERE `id` <> 51683542 AND `partno` = '2797190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182079 [ RunTime:0.006809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241581 LIMIT 5 [ RunTime:0.002366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241581 ORDER BY `minOrder` ASC [ RunTime:0.004867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241581 ORDER BY `unit` DESC [ RunTime:0.001079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241581 LIMIT 2 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241581 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='27970' and brandshort='Parallax Inc.' limit 1 [ RunTime:0.013897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27970' OR `brand` LIKE 'Parallax Inc.%' ) ) LIMIT 1 [ RunTime:0.008104s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241581 AND `partno` = '27970' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%parallax inc.%' ) [ RunTime:0.011578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934635 [ RunTime:0.009651s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001565s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010067s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009972s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012887s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005067s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017674s ]
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 '2797%' OR `brand` LIKE '2797%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005957s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2797%' OR `brand` LIKE '2797%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003764s ]