SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002454s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.194' , `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=10519&search=1' [ RunTime:0.005520s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002228s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002867s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002392s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003353s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002554s ]
SELECT * FROM `stock_search` WHERE `partno` = '10519' LIMIT 1 [ RunTime:0.005430s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-02 21:11:25' WHERE `partno` = '10519' [ RunTime:0.007525s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003725s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021378s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347812 LIMIT 5 [ RunTime:0.011935s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347812 ORDER BY `minOrder` ASC [ RunTime:0.010014s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347812 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347812 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347812 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17152451 LIMIT 5 [ RunTime:0.003363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17152451 ORDER BY `minOrder` ASC [ RunTime:0.010097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17152451 ORDER BY `unit` DESC [ RunTime:0.005153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17152451 LIMIT 2 [ RunTime:0.010661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17152451 ORDER BY `minOrder` ASC [ RunTime:0.007663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867945 LIMIT 5 [ RunTime:0.005846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867945 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12867945 ORDER BY `unit` DESC [ RunTime:0.000309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12867945 LIMIT 2 [ RunTime:0.001314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867945 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190411 LIMIT 5 [ RunTime:0.007125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190411 ORDER BY `minOrder` ASC [ RunTime:0.021190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190411 ORDER BY `unit` DESC [ RunTime:0.006640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190411 LIMIT 2 [ RunTime:0.019327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190411 ORDER BY `minOrder` ASC [ RunTime:0.007388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190351 LIMIT 5 [ RunTime:0.039192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190351 ORDER BY `minOrder` ASC [ RunTime:0.021957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190351 ORDER BY `unit` DESC [ RunTime:0.011828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190351 LIMIT 2 [ RunTime:0.048702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190351 ORDER BY `minOrder` ASC [ RunTime:0.035488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200672 LIMIT 5 [ RunTime:0.016124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200672 ORDER BY `minOrder` ASC [ RunTime:0.012574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200672 ORDER BY `unit` DESC [ RunTime:0.017864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200672 LIMIT 2 [ RunTime:0.017550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200672 ORDER BY `minOrder` ASC [ RunTime:0.006025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200600 LIMIT 5 [ RunTime:0.017829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200600 ORDER BY `minOrder` ASC [ RunTime:0.011126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200600 ORDER BY `unit` DESC [ RunTime:0.032948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200600 LIMIT 2 [ RunTime:0.035139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200600 ORDER BY `minOrder` ASC [ RunTime:0.007417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012135 LIMIT 5 [ RunTime:0.013368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012135 ORDER BY `minOrder` ASC [ RunTime:0.014932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17012135 ORDER BY `unit` DESC [ RunTime:0.019199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17012135 LIMIT 2 [ RunTime:0.021311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17012135 ORDER BY `minOrder` ASC [ RunTime:0.008028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645833 LIMIT 5 [ RunTime:0.019745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645833 ORDER BY `minOrder` ASC [ RunTime:0.023712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19645833 ORDER BY `unit` DESC [ RunTime:0.009596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19645833 LIMIT 2 [ RunTime:0.011138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645833 ORDER BY `minOrder` ASC [ RunTime:0.007870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645832 LIMIT 5 [ RunTime:0.023888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645832 ORDER BY `minOrder` ASC [ RunTime:0.032457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19645832 ORDER BY `unit` DESC [ RunTime:0.076581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19645832 LIMIT 2 [ RunTime:0.012883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645832 ORDER BY `minOrder` ASC [ RunTime:0.008688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637679 LIMIT 5 [ RunTime:0.017748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637679 ORDER BY `minOrder` ASC [ RunTime:0.012656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637679 ORDER BY `unit` DESC [ RunTime:0.023852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637679 LIMIT 2 [ RunTime:0.038760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637679 ORDER BY `minOrder` ASC [ RunTime:0.017452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637552 LIMIT 5 [ RunTime:0.049016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637552 ORDER BY `minOrder` ASC [ RunTime:0.019593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637552 ORDER BY `unit` DESC [ RunTime:0.073254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637552 LIMIT 2 [ RunTime:0.078173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637552 ORDER BY `minOrder` ASC [ RunTime:0.068811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637551 LIMIT 5 [ RunTime:0.050223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637551 ORDER BY `minOrder` ASC [ RunTime:0.090193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637551 ORDER BY `unit` DESC [ RunTime:0.025626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637551 LIMIT 2 [ RunTime:0.070829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637551 ORDER BY `minOrder` ASC [ RunTime:0.019817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636810 LIMIT 5 [ RunTime:0.048239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636810 ORDER BY `minOrder` ASC [ RunTime:0.051214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636810 ORDER BY `unit` DESC [ RunTime:0.051437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636810 LIMIT 2 [ RunTime:0.042214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636810 ORDER BY `minOrder` ASC [ RunTime:0.051267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19610854 LIMIT 5 [ RunTime:0.030048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19610854 ORDER BY `minOrder` ASC [ RunTime:0.074616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19610854 ORDER BY `unit` DESC [ RunTime:0.056163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19610854 LIMIT 2 [ RunTime:0.070161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19610854 ORDER BY `minOrder` ASC [ RunTime:0.011690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981554 LIMIT 5 [ RunTime:0.031119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981554 ORDER BY `minOrder` ASC [ RunTime:0.058951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981554 ORDER BY `unit` DESC [ RunTime:0.039909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981554 LIMIT 2 [ RunTime:0.032073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981554 ORDER BY `minOrder` ASC [ RunTime:0.019921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980549 LIMIT 5 [ RunTime:0.028865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980549 ORDER BY `minOrder` ASC [ RunTime:0.025567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980549 ORDER BY `unit` DESC [ RunTime:0.034841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980549 LIMIT 2 [ RunTime:0.021585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980549 ORDER BY `minOrder` ASC [ RunTime:0.030058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18841118 LIMIT 5 [ RunTime:0.030860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18841118 ORDER BY `minOrder` ASC [ RunTime:0.019711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18841118 ORDER BY `unit` DESC [ RunTime:0.027789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18841118 LIMIT 2 [ RunTime:0.040727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18841118 ORDER BY `minOrder` ASC [ RunTime:0.035744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781559 LIMIT 5 [ RunTime:0.026978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781559 ORDER BY `minOrder` ASC [ RunTime:0.008985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781559 ORDER BY `unit` DESC [ RunTime:0.015422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781559 LIMIT 2 [ RunTime:0.007392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781559 ORDER BY `minOrder` ASC [ RunTime:0.009309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780623 LIMIT 5 [ RunTime:0.011484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780623 ORDER BY `minOrder` ASC [ RunTime:0.013946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780623 ORDER BY `unit` DESC [ RunTime:0.009889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780623 LIMIT 2 [ RunTime:0.017912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780623 ORDER BY `minOrder` ASC [ RunTime:0.017003s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011187s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629459 LIMIT 5 [ RunTime:0.018043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629459 ORDER BY `minOrder` ASC [ RunTime:0.002732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629459 ORDER BY `unit` DESC [ RunTime:0.004446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629459 LIMIT 2 [ RunTime:0.001334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629459 ORDER BY `minOrder` ASC [ RunTime:0.010648s ]
select * from pdf where partno='1051960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013786s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005766s ]
SELECT `id` FROM `stock` WHERE `id` <> 60629459 AND `partno` = '1051960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57737827 LIMIT 5 [ RunTime:0.027891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737827 ORDER BY `minOrder` ASC [ RunTime:0.007049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57737827 ORDER BY `unit` DESC [ RunTime:0.012050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57737827 LIMIT 2 [ RunTime:0.023830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737827 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
select * from pdf where partno='10519CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.030026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10519CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.034882s ]
SELECT `id` FROM `stock` WHERE `id` <> 57737827 AND `partno` = '10519CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.030145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347812 [ RunTime:0.008351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488629 LIMIT 5 [ RunTime:0.022610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488629 ORDER BY `minOrder` ASC [ RunTime:0.026869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488629 ORDER BY `unit` DESC [ RunTime:0.008145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488629 LIMIT 2 [ RunTime:0.022434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488629 ORDER BY `minOrder` ASC [ RunTime:0.013388s ]
select * from pdf where partno='1051910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014545s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488629 AND `partno` = '1051910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.032989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645832 [ RunTime:0.040261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488630 LIMIT 5 [ RunTime:0.047978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488630 ORDER BY `minOrder` ASC [ RunTime:0.021096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488630 ORDER BY `unit` DESC [ RunTime:0.027291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488630 LIMIT 2 [ RunTime:0.022084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488630 ORDER BY `minOrder` ASC [ RunTime:0.032441s ]
select * from pdf where partno='1051940000' and brandshort='Weidmüller' limit 1 [ RunTime:0.031419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051940000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.040385s ]
SELECT `id` FROM `stock` WHERE `id` <> 60488630 AND `partno` = '1051940000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.085814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645833 [ RunTime:0.033071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55094206 LIMIT 5 [ RunTime:0.040636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55094206 ORDER BY `minOrder` ASC [ RunTime:0.045282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55094206 ORDER BY `unit` DESC [ RunTime:0.055430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55094206 LIMIT 2 [ RunTime:0.081570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55094206 ORDER BY `minOrder` ASC [ RunTime:0.053816s ]
select * from pdf where partno='1051908-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.048114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051908-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.079456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58318740 LIMIT 5 [ RunTime:0.035258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58318740 ORDER BY `minOrder` ASC [ RunTime:0.029970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58318740 ORDER BY `unit` DESC [ RunTime:0.017570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58318740 LIMIT 2 [ RunTime:0.055654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58318740 ORDER BY `minOrder` ASC [ RunTime:0.024444s ]
select * from pdf where partno='1051972' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051972' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56521842 LIMIT 5 [ RunTime:0.015073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521842 ORDER BY `minOrder` ASC [ RunTime:0.058819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56521842 ORDER BY `unit` DESC [ RunTime:0.062596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56521842 LIMIT 2 [ RunTime:0.034438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521842 ORDER BY `minOrder` ASC [ RunTime:0.042812s ]
select * from pdf where partno='1051967' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051967' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018818s ]
SELECT `id` FROM `stock` WHERE `id` <> 56521842 AND `partno` = '1051967' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.079535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200672 [ RunTime:0.055601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56521766 LIMIT 5 [ RunTime:0.063121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521766 ORDER BY `minOrder` ASC [ RunTime:0.036008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56521766 ORDER BY `unit` DESC [ RunTime:0.016574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56521766 LIMIT 2 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521766 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
select * from pdf where partno='1051912' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051912' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005535s ]
SELECT `id` FROM `stock` WHERE `id` <> 56521766 AND `partno` = '1051912' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190411 [ RunTime:0.022290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56521711 LIMIT 5 [ RunTime:0.061368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521711 ORDER BY `minOrder` ASC [ RunTime:0.029352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56521711 ORDER BY `unit` DESC [ RunTime:0.031689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56521711 LIMIT 2 [ RunTime:0.039496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521711 ORDER BY `minOrder` ASC [ RunTime:0.002630s ]
select * from pdf where partno='1051910' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051910' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019785s ]
SELECT `id` FROM `stock` WHERE `id` <> 56521711 AND `partno` = '1051910' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.040374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200600 [ RunTime:0.047634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56521677 LIMIT 5 [ RunTime:0.033310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521677 ORDER BY `minOrder` ASC [ RunTime:0.059916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56521677 ORDER BY `unit` DESC [ RunTime:0.049778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56521677 LIMIT 2 [ RunTime:0.032132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56521677 ORDER BY `minOrder` ASC [ RunTime:0.024018s ]
select * from pdf where partno='1051907' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051907' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.041424s ]
SELECT `id` FROM `stock` WHERE `id` <> 56521677 AND `partno` = '1051907' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190351 [ RunTime:0.092693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56464454 LIMIT 5 [ RunTime:0.038368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56464454 ORDER BY `minOrder` ASC [ RunTime:0.088519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56464454 ORDER BY `unit` DESC [ RunTime:0.036827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56464454 LIMIT 2 [ RunTime:0.024537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56464454 ORDER BY `minOrder` ASC [ RunTime:0.017332s ]
select * from pdf where partno='1051971' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051971' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051167s ]
SELECT `id` FROM `stock` WHERE `id` <> 56464454 AND `partno` = '1051971' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.051202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867945 [ RunTime:0.022206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56523759 LIMIT 5 [ RunTime:0.062274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56523759 ORDER BY `minOrder` ASC [ RunTime:0.046829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56523759 ORDER BY `unit` DESC [ RunTime:0.065189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56523759 LIMIT 2 [ RunTime:0.036596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56523759 ORDER BY `minOrder` ASC [ RunTime:0.014125s ]
select * from pdf where partno='1051900' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051900' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022978s ]
SELECT `id` FROM `stock` WHERE `id` <> 56523759 AND `partno` = '1051900' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17012135 [ RunTime:0.004603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60976147 LIMIT 5 [ RunTime:0.016418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60976147 ORDER BY `minOrder` ASC [ RunTime:0.014841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60976147 ORDER BY `unit` DESC [ RunTime:0.073141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60976147 LIMIT 2 [ RunTime:0.026070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60976147 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
select * from pdf where partno='1051990001' and brandshort='Molex' limit 1 [ RunTime:0.013689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051990001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.037194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60974908 LIMIT 5 [ RunTime:0.048893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974908 ORDER BY `minOrder` ASC [ RunTime:0.020983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60974908 ORDER BY `unit` DESC [ RunTime:0.038160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60974908 LIMIT 2 [ RunTime:0.038300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974908 ORDER BY `minOrder` ASC [ RunTime:0.037677s ]
select * from pdf where partno='1051900001' and brandshort='Molex' limit 1 [ RunTime:0.095527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051900001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.054274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622596 LIMIT 5 [ RunTime:0.017619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622596 ORDER BY `minOrder` ASC [ RunTime:0.026956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622596 ORDER BY `unit` DESC [ RunTime:0.013934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622596 LIMIT 2 [ RunTime:0.012308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622596 ORDER BY `minOrder` ASC [ RunTime:0.002311s ]
select * from pdf where partno='1051993' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.033529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051993' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.049716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60587442 LIMIT 5 [ RunTime:0.035366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60587442 ORDER BY `minOrder` ASC [ RunTime:0.043344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60587442 ORDER BY `unit` DESC [ RunTime:0.063976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60587442 LIMIT 2 [ RunTime:0.015248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60587442 ORDER BY `minOrder` ASC [ RunTime:0.003654s ]
select * from pdf where partno='10519.4' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.032087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10519.4' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.014660s ]
SELECT `id` FROM `stock` WHERE `id` <> 60587442 AND `partno` = '10519.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.027918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12549530 [ RunTime:0.019579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60587441 LIMIT 5 [ RunTime:0.019571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60587441 ORDER BY `minOrder` ASC [ RunTime:0.023845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60587441 ORDER BY `unit` DESC [ RunTime:0.025934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60587441 LIMIT 2 [ RunTime:0.010991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60587441 ORDER BY `minOrder` ASC [ RunTime:0.011588s ]
select * from pdf where partno='10519.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.006259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10519.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.011849s ]
SELECT `id` FROM `stock` WHERE `id` <> 60587441 AND `partno` = '10519.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.032428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12549529 [ RunTime:0.035180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60531992 LIMIT 5 [ RunTime:0.017152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60531992 ORDER BY `minOrder` ASC [ RunTime:0.089540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60531992 ORDER BY `unit` DESC [ RunTime:0.069001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60531992 LIMIT 2 [ RunTime:0.009323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60531992 ORDER BY `minOrder` ASC [ RunTime:0.032670s ]
select * from pdf where partno='1051920000' and brandshort='Weidmüller' limit 1 [ RunTime:0.035318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051920000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031539s ]
SELECT `id` FROM `stock` WHERE `id` <> 60531992 AND `partno` = '1051920000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.024163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637679 [ RunTime:0.038658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60530792 LIMIT 5 [ RunTime:0.061207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60530792 ORDER BY `minOrder` ASC [ RunTime:0.118814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60530792 ORDER BY `unit` DESC [ RunTime:0.046265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60530792 LIMIT 2 [ RunTime:0.029836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60530792 ORDER BY `minOrder` ASC [ RunTime:0.057420s ]
select * from pdf where partno='1051950000' and brandshort='Weidmüller' limit 1 [ RunTime:0.052682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051950000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017563s ]
SELECT `id` FROM `stock` WHERE `id` <> 60530792 AND `partno` = '1051950000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.038248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636810 [ RunTime:0.024221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60493972 LIMIT 5 [ RunTime:0.004696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60493972 ORDER BY `minOrder` ASC [ RunTime:0.033476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60493972 ORDER BY `unit` DESC [ RunTime:0.015821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60493972 LIMIT 2 [ RunTime:0.005766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60493972 ORDER BY `minOrder` ASC [ RunTime:0.007208s ]
select * from pdf where partno='1051980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1051980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018419s ]
SELECT `id` FROM `stock` WHERE `id` <> 60493972 AND `partno` = '1051980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637552 [ RunTime:0.043801s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023030s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058416s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051634s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021543s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030071s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018162s ]
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 '10519%' OR `brand` LIKE '10519%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009811s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10519%' OR `brand` LIKE '10519%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.042703s ]