SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002025s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.127' , `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=943940999-23&search=1' [ RunTime:0.045397s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003359s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011498s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001340s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.127' ) [ RunTime:0.011348s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001178s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010895s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002913s ]
SELECT * FROM `stock_search` WHERE `partno` = '943940999-23' LIMIT 1 [ RunTime:0.008830s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-29 02:37:05' WHERE `partno` = '943940999-23' [ RunTime:0.010109s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001266s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010829s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278540 LIMIT 5 [ RunTime:0.038234s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278540 ORDER BY `minOrder` ASC [ RunTime:0.033370s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278540 ORDER BY `unit` DESC [ RunTime:0.073020s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278540 LIMIT 2 [ RunTime:0.012327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278540 ORDER BY `minOrder` ASC [ RunTime:0.002884s ]
select * from pdf where partno='943940999-232' and brandshort='Hirschmann' limit 1 [ RunTime:0.008666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278518 LIMIT 5 [ RunTime:0.023937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278518 ORDER BY `minOrder` ASC [ RunTime:0.032295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278518 ORDER BY `unit` DESC [ RunTime:0.128431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278518 LIMIT 2 [ RunTime:0.051058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278518 ORDER BY `minOrder` ASC [ RunTime:0.029690s ]
select * from pdf where partno='943940999-234' and brandshort='Hirschmann' limit 1 [ RunTime:0.055455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278508 LIMIT 5 [ RunTime:0.090329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278508 ORDER BY `minOrder` ASC [ RunTime:0.077989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278508 ORDER BY `unit` DESC [ RunTime:0.060610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278508 LIMIT 2 [ RunTime:0.037925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278508 ORDER BY `minOrder` ASC [ RunTime:0.022087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278496 LIMIT 5 [ RunTime:0.226669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278496 ORDER BY `minOrder` ASC [ RunTime:0.027804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278496 ORDER BY `unit` DESC [ RunTime:0.166027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278496 LIMIT 2 [ RunTime:0.024733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278496 ORDER BY `minOrder` ASC [ RunTime:0.016973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278221 LIMIT 5 [ RunTime:0.068719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278221 ORDER BY `minOrder` ASC [ RunTime:0.080831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278221 ORDER BY `unit` DESC [ RunTime:0.077610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278221 LIMIT 2 [ RunTime:0.050399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278221 ORDER BY `minOrder` ASC [ RunTime:0.026932s ]
select * from pdf where partno='943940999-235' and brandshort='Hirschmann' limit 1 [ RunTime:0.046573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278151 LIMIT 5 [ RunTime:0.116785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278151 ORDER BY `minOrder` ASC [ RunTime:0.033282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13278151 ORDER BY `unit` DESC [ RunTime:0.087727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13278151 LIMIT 2 [ RunTime:0.092989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13278151 ORDER BY `minOrder` ASC [ RunTime:0.076573s ]
select * from pdf where partno='943940999-239' and brandshort='Hirschmann' limit 1 [ RunTime:0.104502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006325 LIMIT 5 [ RunTime:0.123290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006325 ORDER BY `minOrder` ASC [ RunTime:0.055344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006325 ORDER BY `unit` DESC [ RunTime:0.140341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006325 LIMIT 2 [ RunTime:0.080643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006325 ORDER BY `minOrder` ASC [ RunTime:0.025860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006233 LIMIT 5 [ RunTime:0.077436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006233 ORDER BY `minOrder` ASC [ RunTime:0.060622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006233 ORDER BY `unit` DESC [ RunTime:0.147097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006233 LIMIT 2 [ RunTime:0.011045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006233 ORDER BY `minOrder` ASC [ RunTime:0.023541s ]
select * from pdf where partno='943940999-237' and brandshort='Hirschmann' limit 1 [ RunTime:0.068749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006206 LIMIT 5 [ RunTime:0.025143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006206 ORDER BY `minOrder` ASC [ RunTime:0.023325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006206 ORDER BY `unit` DESC [ RunTime:0.032575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006206 LIMIT 2 [ RunTime:0.050393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006206 ORDER BY `minOrder` ASC [ RunTime:0.074174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006168 LIMIT 5 [ RunTime:0.048144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006168 ORDER BY `minOrder` ASC [ RunTime:0.002919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12006168 ORDER BY `unit` DESC [ RunTime:0.042537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12006168 LIMIT 2 [ RunTime:0.028970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12006168 ORDER BY `minOrder` ASC [ RunTime:0.054328s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031288s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.100336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388931 LIMIT 5 [ RunTime:0.042353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388931 ORDER BY `minOrder` ASC [ RunTime:0.020684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388931 ORDER BY `unit` DESC [ RunTime:0.013620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388931 LIMIT 2 [ RunTime:0.028654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388931 ORDER BY `minOrder` ASC [ RunTime:0.016158s ]
select * from pdf where partno='943940999-232' and brandshort='Hirschmann' limit 1 [ RunTime:0.040255s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-232' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.037409s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388931 AND `partno` = '943940999-232' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.020743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278540 [ RunTime:0.069647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388853 LIMIT 5 [ RunTime:0.031740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388853 ORDER BY `minOrder` ASC [ RunTime:0.046136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388853 ORDER BY `unit` DESC [ RunTime:0.075093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388853 LIMIT 2 [ RunTime:0.039351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388853 ORDER BY `minOrder` ASC [ RunTime:0.027164s ]
select * from pdf where partno='943940999-234' and brandshort='Hirschmann' limit 1 [ RunTime:0.016004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-234' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.078386s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388853 AND `partno` = '943940999-234' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.066361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278518 [ RunTime:0.053991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388834 LIMIT 5 [ RunTime:0.021581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388834 ORDER BY `minOrder` ASC [ RunTime:0.128410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388834 ORDER BY `unit` DESC [ RunTime:0.182256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388834 LIMIT 2 [ RunTime:0.099086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388834 ORDER BY `minOrder` ASC [ RunTime:0.034194s ]
select * from pdf where partno='943940999-236' and brandshort='Hirschmann' limit 1 [ RunTime:0.062597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-236' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.135048s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388834 AND `partno` = '943940999-236' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.036670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278508 [ RunTime:0.105157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388803 LIMIT 5 [ RunTime:0.161224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388803 ORDER BY `minOrder` ASC [ RunTime:0.137578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388803 ORDER BY `unit` DESC [ RunTime:0.062990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388803 LIMIT 2 [ RunTime:0.111545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388803 ORDER BY `minOrder` ASC [ RunTime:0.057853s ]
select * from pdf where partno='943940999-233' and brandshort='Hirschmann' limit 1 [ RunTime:0.061126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-233' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.050267s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388803 AND `partno` = '943940999-233' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.067574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278496 [ RunTime:0.041592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388245 LIMIT 5 [ RunTime:0.050791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388245 ORDER BY `minOrder` ASC [ RunTime:0.089284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388245 ORDER BY `unit` DESC [ RunTime:0.102189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388245 LIMIT 2 [ RunTime:0.040831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388245 ORDER BY `minOrder` ASC [ RunTime:0.046525s ]
select * from pdf where partno='943940999-230' and brandshort='Hirschmann' limit 1 [ RunTime:0.073585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-230' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.074544s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388245 AND `partno` = '943940999-230' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.188330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006325 [ RunTime:0.131517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388069 LIMIT 5 [ RunTime:0.094678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388069 ORDER BY `minOrder` ASC [ RunTime:0.136941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388069 ORDER BY `unit` DESC [ RunTime:0.067132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388069 LIMIT 2 [ RunTime:0.070168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388069 ORDER BY `minOrder` ASC [ RunTime:0.068171s ]
select * from pdf where partno='943940999-237' and brandshort='Hirschmann' limit 1 [ RunTime:0.035664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-237' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.057696s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388069 AND `partno` = '943940999-237' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.088689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006233 [ RunTime:0.057046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64388000 LIMIT 5 [ RunTime:0.046202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388000 ORDER BY `minOrder` ASC [ RunTime:0.095715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64388000 ORDER BY `unit` DESC [ RunTime:0.002661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64388000 LIMIT 2 [ RunTime:0.010224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64388000 ORDER BY `minOrder` ASC [ RunTime:0.015315s ]
select * from pdf where partno='943940999-235' and brandshort='Hirschmann' limit 1 [ RunTime:0.039046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-235' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.040866s ]
SELECT `id` FROM `stock` WHERE `id` <> 64388000 AND `partno` = '943940999-235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.067239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278221 [ RunTime:0.043778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387950 LIMIT 5 [ RunTime:0.036858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387950 ORDER BY `minOrder` ASC [ RunTime:0.138823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387950 ORDER BY `unit` DESC [ RunTime:0.016009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387950 LIMIT 2 [ RunTime:0.055671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387950 ORDER BY `minOrder` ASC [ RunTime:0.014422s ]
select * from pdf where partno='943940999-238' and brandshort='Hirschmann' limit 1 [ RunTime:0.015536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-238' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.047360s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387950 AND `partno` = '943940999-238' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.056360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006206 [ RunTime:0.050139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387946 LIMIT 5 [ RunTime:0.044322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387946 ORDER BY `minOrder` ASC [ RunTime:0.054183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387946 ORDER BY `unit` DESC [ RunTime:0.048911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387946 LIMIT 2 [ RunTime:0.030499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387946 ORDER BY `minOrder` ASC [ RunTime:0.010315s ]
select * from pdf where partno='943940999-23' and brandshort='Hirschmann' limit 1 [ RunTime:0.018080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-23' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.041939s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387946 AND `partno` = '943940999-23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.053321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12006168 [ RunTime:0.064693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64387808 LIMIT 5 [ RunTime:0.037625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387808 ORDER BY `minOrder` ASC [ RunTime:0.029484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64387808 ORDER BY `unit` DESC [ RunTime:0.042386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64387808 LIMIT 2 [ RunTime:0.015571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64387808 ORDER BY `minOrder` ASC [ RunTime:0.033717s ]
select * from pdf where partno='943940999-239' and brandshort='Hirschmann' limit 1 [ RunTime:0.005209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943940999-239' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.020696s ]
SELECT `id` FROM `stock` WHERE `id` <> 64387808 AND `partno` = '943940999-239' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.025424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13278151 [ RunTime:0.015814s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030902s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039512s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041505s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018802s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039329s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022980s ]
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 '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049686s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '943940999-23%' OR `brand` LIKE '943940999-23%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027628s ]