SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002387s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=25660&search=1' [ RunTime:0.002073s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001393s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001653s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.002795s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001196s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003310s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001520s ]
SELECT * FROM `stock_search` WHERE `partno` = '25660' LIMIT 1 [ RunTime:0.006793s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 11:15:57' WHERE `partno` = '25660' [ RunTime:0.026904s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001533s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005512s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11961002 LIMIT 5 [ RunTime:0.017005s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11961002 ORDER BY `minOrder` ASC [ RunTime:0.013371s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11961002 ORDER BY `unit` DESC [ RunTime:0.018765s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11961002 LIMIT 2 [ RunTime:0.010252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11961002 ORDER BY `minOrder` ASC [ RunTime:0.001447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851162 LIMIT 5 [ RunTime:0.020668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851162 ORDER BY `minOrder` ASC [ RunTime:0.012006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18851162 ORDER BY `unit` DESC [ RunTime:0.018391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18851162 LIMIT 2 [ RunTime:0.029508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851162 ORDER BY `minOrder` ASC [ RunTime:0.041290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104150 LIMIT 5 [ RunTime:0.049404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104150 ORDER BY `minOrder` ASC [ RunTime:0.052775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104150 ORDER BY `unit` DESC [ RunTime:0.027925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104150 LIMIT 2 [ RunTime:0.025754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104150 ORDER BY `minOrder` ASC [ RunTime:0.014104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104149 LIMIT 5 [ RunTime:0.027725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104149 ORDER BY `minOrder` ASC [ RunTime:0.052169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104149 ORDER BY `unit` DESC [ RunTime:0.033699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104149 LIMIT 2 [ RunTime:0.061422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104149 ORDER BY `minOrder` ASC [ RunTime:0.025150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104101 LIMIT 5 [ RunTime:0.032313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104101 ORDER BY `minOrder` ASC [ RunTime:0.012204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104101 ORDER BY `unit` DESC [ RunTime:0.025274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104101 LIMIT 2 [ RunTime:0.018983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104101 ORDER BY `minOrder` ASC [ RunTime:0.027512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104100 LIMIT 5 [ RunTime:0.014436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104100 ORDER BY `minOrder` ASC [ RunTime:0.057486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104100 ORDER BY `unit` DESC [ RunTime:0.033849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104100 LIMIT 2 [ RunTime:0.022358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104100 ORDER BY `minOrder` ASC [ RunTime:0.032506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851358 LIMIT 5 [ RunTime:0.046202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851358 ORDER BY `minOrder` ASC [ RunTime:0.035865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11851358 ORDER BY `unit` DESC [ RunTime:0.014631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11851358 LIMIT 2 [ RunTime:0.017312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851358 ORDER BY `minOrder` ASC [ RunTime:0.020711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851357 LIMIT 5 [ RunTime:0.029733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851357 ORDER BY `minOrder` ASC [ RunTime:0.019146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11851357 ORDER BY `unit` DESC [ RunTime:0.006518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11851357 LIMIT 2 [ RunTime:0.019315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851357 ORDER BY `minOrder` ASC [ RunTime:0.003598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851356 LIMIT 5 [ RunTime:0.016051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851356 ORDER BY `minOrder` ASC [ RunTime:0.018847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11851356 ORDER BY `unit` DESC [ RunTime:0.016748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11851356 LIMIT 2 [ RunTime:0.013486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851356 ORDER BY `minOrder` ASC [ RunTime:0.010667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851355 LIMIT 5 [ RunTime:0.021090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851355 ORDER BY `minOrder` ASC [ RunTime:0.019530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11851355 ORDER BY `unit` DESC [ RunTime:0.022117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11851355 LIMIT 2 [ RunTime:0.049060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851355 ORDER BY `minOrder` ASC [ RunTime:0.012437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851354 LIMIT 5 [ RunTime:0.043517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851354 ORDER BY `minOrder` ASC [ RunTime:0.035257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11851354 ORDER BY `unit` DESC [ RunTime:0.004317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11851354 LIMIT 2 [ RunTime:0.017246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11851354 ORDER BY `minOrder` ASC [ RunTime:0.035757s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020915s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56456952 LIMIT 5 [ RunTime:0.034080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456952 ORDER BY `minOrder` ASC [ RunTime:0.031617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56456952 ORDER BY `unit` DESC [ RunTime:0.009203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56456952 LIMIT 2 [ RunTime:0.028032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456952 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
select * from pdf where partno='25660' and brandshort='Phoenix America' limit 1 [ RunTime:0.034216s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25660' OR `brand` LIKE 'Phoenix America%' ) ) LIMIT 1 [ RunTime:0.000629s ]
SELECT `id` FROM `stock` WHERE `id` <> 56456952 AND `partno` = '25660' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%phoenix america%' ) [ RunTime:0.035278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57297758 LIMIT 5 [ RunTime:0.029982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57297758 ORDER BY `minOrder` ASC [ RunTime:0.032425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57297758 ORDER BY `unit` DESC [ RunTime:0.014495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57297758 LIMIT 2 [ RunTime:0.070861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57297758 ORDER BY `minOrder` ASC [ RunTime:0.026806s ]
select * from pdf where partno='2566090000' and brandshort='Weidmüller' limit 1 [ RunTime:0.053060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566090000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016564s ]
SELECT `id` FROM `stock` WHERE `id` <> 57297758 AND `partno` = '2566090000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.025335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851162 [ RunTime:0.032482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56264701 LIMIT 5 [ RunTime:0.055943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56264701 ORDER BY `minOrder` ASC [ RunTime:0.048155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56264701 ORDER BY `unit` DESC [ RunTime:0.018212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56264701 LIMIT 2 [ RunTime:0.033446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56264701 ORDER BY `minOrder` ASC [ RunTime:0.019584s ]
select * from pdf where partno='25660.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.016896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25660.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.017616s ]
SELECT `id` FROM `stock` WHERE `id` <> 56264701 AND `partno` = '25660.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.054370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572370 LIMIT 5 [ RunTime:0.050636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572370 ORDER BY `minOrder` ASC [ RunTime:0.020097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572370 ORDER BY `unit` DESC [ RunTime:0.044053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572370 LIMIT 2 [ RunTime:0.052390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572370 ORDER BY `minOrder` ASC [ RunTime:0.010668s ]
select * from pdf where partno='2566080000' and brandshort='Weidmüller' limit 1 [ RunTime:0.019548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566080000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.023868s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572370 AND `partno` = '2566080000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.024169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104150 [ RunTime:0.014086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572365 LIMIT 5 [ RunTime:0.055049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572365 ORDER BY `minOrder` ASC [ RunTime:0.032322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572365 ORDER BY `unit` DESC [ RunTime:0.009308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572365 LIMIT 2 [ RunTime:0.018820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572365 ORDER BY `minOrder` ASC [ RunTime:0.031379s ]
select * from pdf where partno='2566070000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566070000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.050616s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572365 AND `partno` = '2566070000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.056532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104149 [ RunTime:0.028474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572253 LIMIT 5 [ RunTime:0.035281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572253 ORDER BY `minOrder` ASC [ RunTime:0.019826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572253 ORDER BY `unit` DESC [ RunTime:0.101794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572253 LIMIT 2 [ RunTime:0.039646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572253 ORDER BY `minOrder` ASC [ RunTime:0.019173s ]
select * from pdf where partno='2566020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.042311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.030912s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572253 AND `partno` = '2566020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.050475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851358 [ RunTime:0.059536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572252 LIMIT 5 [ RunTime:0.038680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572252 ORDER BY `minOrder` ASC [ RunTime:0.080046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572252 ORDER BY `unit` DESC [ RunTime:0.033972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572252 LIMIT 2 [ RunTime:0.037844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572252 ORDER BY `minOrder` ASC [ RunTime:0.052231s ]
select * from pdf where partno='2566000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.076084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566000000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.049358s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572252 AND `partno` = '2566000000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.085980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851357 [ RunTime:0.065064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572251 LIMIT 5 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572251 ORDER BY `minOrder` ASC [ RunTime:0.071887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572251 ORDER BY `unit` DESC [ RunTime:0.057329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572251 LIMIT 2 [ RunTime:0.037378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572251 ORDER BY `minOrder` ASC [ RunTime:0.072441s ]
select * from pdf where partno='2566010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.041220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.023198s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572251 AND `partno` = '2566010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.042930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851356 [ RunTime:0.026605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572250 LIMIT 5 [ RunTime:0.012264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572250 ORDER BY `minOrder` ASC [ RunTime:0.012513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572250 ORDER BY `unit` DESC [ RunTime:0.027401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572250 LIMIT 2 [ RunTime:0.043633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572250 ORDER BY `minOrder` ASC [ RunTime:0.017122s ]
select * from pdf where partno='2566030000' and brandshort='Weidmüller' limit 1 [ RunTime:0.066896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566030000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.036162s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572250 AND `partno` = '2566030000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.053148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851355 [ RunTime:0.053736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572249 LIMIT 5 [ RunTime:0.049625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572249 ORDER BY `minOrder` ASC [ RunTime:0.038197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572249 ORDER BY `unit` DESC [ RunTime:0.024422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572249 LIMIT 2 [ RunTime:0.027150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572249 ORDER BY `minOrder` ASC [ RunTime:0.029994s ]
select * from pdf where partno='2566060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.024008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029045s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572249 AND `partno` = '2566060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.019545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104100 [ RunTime:0.050607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53572248 LIMIT 5 [ RunTime:0.019217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572248 ORDER BY `minOrder` ASC [ RunTime:0.015012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53572248 ORDER BY `unit` DESC [ RunTime:0.025275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53572248 LIMIT 2 [ RunTime:0.023204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53572248 ORDER BY `minOrder` ASC [ RunTime:0.021095s ]
select * from pdf where partno='2566050000' and brandshort='Weidmüller' limit 1 [ RunTime:0.025395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566050000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.046956s ]
SELECT `id` FROM `stock` WHERE `id` <> 53572248 AND `partno` = '2566050000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.043837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11851354 [ RunTime:0.048595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53570306 LIMIT 5 [ RunTime:0.026180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53570306 ORDER BY `minOrder` ASC [ RunTime:0.032791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53570306 ORDER BY `unit` DESC [ RunTime:0.015674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53570306 LIMIT 2 [ RunTime:0.052082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53570306 ORDER BY `minOrder` ASC [ RunTime:0.015491s ]
select * from pdf where partno='2566040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.029475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.037043s ]
SELECT `id` FROM `stock` WHERE `id` <> 53570306 AND `partno` = '2566040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.020976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104101 [ RunTime:0.053477s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028744s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057291s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024460s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038188s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040253s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038778s ]
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 '25660%' OR `brand` LIKE '25660%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018124s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25660%' OR `brand` LIKE '25660%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022081s ]