SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001931s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=4710&search=1' [ RunTime:0.029131s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002178s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.031461s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002640s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002479s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003046s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002169s ]
SELECT * FROM `stock_search` WHERE `partno` = '4710' LIMIT 1 [ RunTime:0.047289s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-24 04:05:38' WHERE `partno` = '4710' [ RunTime:0.034084s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001592s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.109051s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.040431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596291 LIMIT 5 [ RunTime:0.117056s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596291 ORDER BY `minOrder` ASC [ RunTime:0.041175s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596291 ORDER BY `unit` DESC [ RunTime:0.049931s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596291 LIMIT 2 [ RunTime:0.035465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596291 ORDER BY `minOrder` ASC [ RunTime:0.030154s ]
select * from pdf where partno='4710KL-04W-B59-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.079723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182103 LIMIT 5 [ RunTime:0.042446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182103 ORDER BY `minOrder` ASC [ RunTime:0.043096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15182103 ORDER BY `unit` DESC [ RunTime:0.071818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15182103 LIMIT 2 [ RunTime:0.013363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182103 ORDER BY `minOrder` ASC [ RunTime:0.069626s ]
select * from pdf where partno='4710KL-04W-B20-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.029347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182104 LIMIT 5 [ RunTime:0.127881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182104 ORDER BY `minOrder` ASC [ RunTime:0.139651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15182104 ORDER BY `unit` DESC [ RunTime:0.049771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15182104 LIMIT 2 [ RunTime:0.094392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182104 ORDER BY `minOrder` ASC [ RunTime:0.065244s ]
select * from pdf where partno='4710KL-04W-B50-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.072626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17292965 LIMIT 5 [ RunTime:0.069815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17292965 ORDER BY `minOrder` ASC [ RunTime:0.045152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17292965 ORDER BY `unit` DESC [ RunTime:0.052372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17292965 LIMIT 2 [ RunTime:0.027090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17292965 ORDER BY `minOrder` ASC [ RunTime:0.039292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15436372 LIMIT 5 [ RunTime:0.081359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15436372 ORDER BY `minOrder` ASC [ RunTime:0.055899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15436372 ORDER BY `unit` DESC [ RunTime:0.006469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15436372 LIMIT 2 [ RunTime:0.019566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15436372 ORDER BY `minOrder` ASC [ RunTime:0.017053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13113638 LIMIT 5 [ RunTime:0.013243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13113638 ORDER BY `minOrder` ASC [ RunTime:0.015589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13113638 ORDER BY `unit` DESC [ RunTime:0.008324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13113638 LIMIT 2 [ RunTime:0.002271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13113638 ORDER BY `minOrder` ASC [ RunTime:0.007811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553531 LIMIT 5 [ RunTime:0.008032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553531 ORDER BY `minOrder` ASC [ RunTime:0.026875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19553531 ORDER BY `unit` DESC [ RunTime:0.011732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19553531 LIMIT 2 [ RunTime:0.032862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553531 ORDER BY `minOrder` ASC [ RunTime:0.005041s ]
select * from pdf where partno='471006268142' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19564438 LIMIT 5 [ RunTime:0.009624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19564438 ORDER BY `minOrder` ASC [ RunTime:0.021776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19564438 ORDER BY `unit` DESC [ RunTime:0.011151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19564438 LIMIT 2 [ RunTime:0.007865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19564438 ORDER BY `minOrder` ASC [ RunTime:0.007819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17294437 LIMIT 5 [ RunTime:0.009551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17294437 ORDER BY `minOrder` ASC [ RunTime:0.023169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17294437 ORDER BY `unit` DESC [ RunTime:0.009586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17294437 LIMIT 2 [ RunTime:0.026082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17294437 ORDER BY `minOrder` ASC [ RunTime:0.010027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19561175 LIMIT 5 [ RunTime:0.021595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19561175 ORDER BY `minOrder` ASC [ RunTime:0.013479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19561175 ORDER BY `unit` DESC [ RunTime:0.005241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19561175 LIMIT 2 [ RunTime:0.010849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19561175 ORDER BY `minOrder` ASC [ RunTime:0.009916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008734 LIMIT 5 [ RunTime:0.008421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008734 ORDER BY `minOrder` ASC [ RunTime:0.009812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16008734 ORDER BY `unit` DESC [ RunTime:0.006510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16008734 LIMIT 2 [ RunTime:0.006328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008734 ORDER BY `minOrder` ASC [ RunTime:0.006408s ]
select * from pdf where partno='4710KL-04W-B30-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.014368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553532 LIMIT 5 [ RunTime:0.015309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553532 ORDER BY `minOrder` ASC [ RunTime:0.015077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19553532 ORDER BY `unit` DESC [ RunTime:0.005820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19553532 LIMIT 2 [ RunTime:0.025019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553532 ORDER BY `minOrder` ASC [ RunTime:0.010155s ]
select * from pdf where partno='471006268143' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13113639 LIMIT 5 [ RunTime:0.022075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13113639 ORDER BY `minOrder` ASC [ RunTime:0.023871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13113639 ORDER BY `unit` DESC [ RunTime:0.021532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13113639 LIMIT 2 [ RunTime:0.027778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13113639 ORDER BY `minOrder` ASC [ RunTime:0.015875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553518 LIMIT 5 [ RunTime:0.026417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553518 ORDER BY `minOrder` ASC [ RunTime:0.041773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19553518 ORDER BY `unit` DESC [ RunTime:0.029184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19553518 LIMIT 2 [ RunTime:0.012498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553518 ORDER BY `minOrder` ASC [ RunTime:0.025172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295133 LIMIT 5 [ RunTime:0.031490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295133 ORDER BY `minOrder` ASC [ RunTime:0.091086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17295133 ORDER BY `unit` DESC [ RunTime:0.052616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17295133 LIMIT 2 [ RunTime:0.041409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17295133 ORDER BY `minOrder` ASC [ RunTime:0.010646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553522 LIMIT 5 [ RunTime:0.016420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553522 ORDER BY `minOrder` ASC [ RunTime:0.001436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19553522 ORDER BY `unit` DESC [ RunTime:0.013350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19553522 LIMIT 2 [ RunTime:0.028913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553522 ORDER BY `minOrder` ASC [ RunTime:0.048455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553523 LIMIT 5 [ RunTime:0.037455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553523 ORDER BY `minOrder` ASC [ RunTime:0.024432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19553523 ORDER BY `unit` DESC [ RunTime:0.009604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19553523 LIMIT 2 [ RunTime:0.043798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19553523 ORDER BY `minOrder` ASC [ RunTime:0.016786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11858397 LIMIT 5 [ RunTime:0.037336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11858397 ORDER BY `minOrder` ASC [ RunTime:0.044221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11858397 ORDER BY `unit` DESC [ RunTime:0.078212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11858397 LIMIT 2 [ RunTime:0.016737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11858397 ORDER BY `minOrder` ASC [ RunTime:0.044139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857749 LIMIT 5 [ RunTime:0.014150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857749 ORDER BY `minOrder` ASC [ RunTime:0.022117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11857749 ORDER BY `unit` DESC [ RunTime:0.050697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11857749 LIMIT 2 [ RunTime:0.021072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857749 ORDER BY `minOrder` ASC [ RunTime:0.012977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857748 LIMIT 5 [ RunTime:0.016093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857748 ORDER BY `minOrder` ASC [ RunTime:0.017493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11857748 ORDER BY `unit` DESC [ RunTime:0.031777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11857748 LIMIT 2 [ RunTime:0.024483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857748 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028445s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58478018 LIMIT 5 [ RunTime:0.026537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478018 ORDER BY `minOrder` ASC [ RunTime:0.023602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58478018 ORDER BY `unit` DESC [ RunTime:0.024468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58478018 LIMIT 2 [ RunTime:0.034770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478018 ORDER BY `minOrder` ASC [ RunTime:0.011915s ]
select * from pdf where partno='4710KL-04W-B20-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.009990s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710KL-04W-B20-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.033967s ]
SELECT `id` FROM `stock` WHERE `id` <> 58478018 AND `partno` = '4710KL-04W-B20-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.015670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182103 [ RunTime:0.031356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58478024 LIMIT 5 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478024 ORDER BY `minOrder` ASC [ RunTime:0.051794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58478024 ORDER BY `unit` DESC [ RunTime:0.014392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58478024 LIMIT 2 [ RunTime:0.035965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478024 ORDER BY `minOrder` ASC [ RunTime:0.007864s ]
select * from pdf where partno='4710KL-04W-B59-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.003949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710KL-04W-B59-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.028594s ]
SELECT `id` FROM `stock` WHERE `id` <> 58478024 AND `partno` = '4710KL-04W-B59-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.029893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596291 [ RunTime:0.032673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780711 LIMIT 5 [ RunTime:0.051764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780711 ORDER BY `minOrder` ASC [ RunTime:0.049752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780711 ORDER BY `unit` DESC [ RunTime:0.024970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780711 LIMIT 2 [ RunTime:0.012644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780711 ORDER BY `minOrder` ASC [ RunTime:0.015834s ]
select * from pdf where partno='471002268142' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.060557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471002268142' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.032776s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780711 AND `partno` = '471002268142' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17292965 [ RunTime:0.007252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780741 LIMIT 5 [ RunTime:0.032405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780741 ORDER BY `minOrder` ASC [ RunTime:0.033259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780741 ORDER BY `unit` DESC [ RunTime:0.016117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780741 LIMIT 2 [ RunTime:0.019140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780741 ORDER BY `minOrder` ASC [ RunTime:0.002107s ]
select * from pdf where partno='471006268143' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471006268143' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.020687s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780741 AND `partno` = '471006268143' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.029848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553532 [ RunTime:0.052132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780742 LIMIT 5 [ RunTime:0.076216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780742 ORDER BY `minOrder` ASC [ RunTime:0.012559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780742 ORDER BY `unit` DESC [ RunTime:0.025353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780742 LIMIT 2 [ RunTime:0.005955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780742 ORDER BY `minOrder` ASC [ RunTime:0.025146s ]
select * from pdf where partno='471006268142' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471006268142' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.077083s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780742 AND `partno` = '471006268142' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.036932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553531 [ RunTime:0.070476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58726705 LIMIT 5 [ RunTime:0.026310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726705 ORDER BY `minOrder` ASC [ RunTime:0.036554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58726705 ORDER BY `unit` DESC [ RunTime:0.028477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58726705 LIMIT 2 [ RunTime:0.025009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726705 ORDER BY `minOrder` ASC [ RunTime:0.018013s ]
select * from pdf where partno='4710.3015' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.033601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710.3015' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.033184s ]
SELECT `id` FROM `stock` WHERE `id` <> 58726705 AND `partno` = '4710.3015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.103990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13113638 [ RunTime:0.047514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780714 LIMIT 5 [ RunTime:0.031020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780714 ORDER BY `minOrder` ASC [ RunTime:0.029278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780714 ORDER BY `unit` DESC [ RunTime:0.035286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780714 LIMIT 2 [ RunTime:0.033744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780714 ORDER BY `minOrder` ASC [ RunTime:0.036238s ]
select * from pdf where partno='471001264142' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.030174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471001264142' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.033468s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780714 AND `partno` = '471001264142' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12864 [ RunTime:0.012007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19564438 [ RunTime:0.014834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780725 LIMIT 5 [ RunTime:0.019011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780725 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780725 ORDER BY `unit` DESC [ RunTime:0.014047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780725 LIMIT 2 [ RunTime:0.011067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780725 ORDER BY `minOrder` ASC [ RunTime:0.008905s ]
select * from pdf where partno='471015264153' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.018666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471015264153' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014649s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780725 AND `partno` = '471015264153' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19561175 [ RunTime:0.018982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58726706 LIMIT 5 [ RunTime:0.040652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726706 ORDER BY `minOrder` ASC [ RunTime:0.019057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58726706 ORDER BY `unit` DESC [ RunTime:0.010207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58726706 LIMIT 2 [ RunTime:0.007385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726706 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
select * from pdf where partno='4710.6014' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.011147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710.6014' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.011989s ]
SELECT `id` FROM `stock` WHERE `id` <> 58726706 AND `partno` = '4710.6014' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.027942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13113639 [ RunTime:0.003384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780728 LIMIT 5 [ RunTime:0.009983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780728 ORDER BY `minOrder` ASC [ RunTime:0.030747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780728 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780728 LIMIT 2 [ RunTime:0.002422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780728 ORDER BY `minOrder` ASC [ RunTime:0.005131s ]
select * from pdf where partno='471016264143' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.026430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471016264143' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007735s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780728 AND `partno` = '471016264143' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15436372 [ RunTime:0.006547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780712 LIMIT 5 [ RunTime:0.017157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780712 ORDER BY `minOrder` ASC [ RunTime:0.008266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780712 ORDER BY `unit` DESC [ RunTime:0.008328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780712 LIMIT 2 [ RunTime:0.005747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780712 ORDER BY `minOrder` ASC [ RunTime:0.018797s ]
select * from pdf where partno='471002268143' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471002268143' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.013069s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780712 AND `partno` = '471002268143' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17295133 [ RunTime:0.012445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780788 LIMIT 5 [ RunTime:0.008259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780788 ORDER BY `minOrder` ASC [ RunTime:0.003499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780788 ORDER BY `unit` DESC [ RunTime:0.006885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780788 LIMIT 2 [ RunTime:0.010025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780788 ORDER BY `minOrder` ASC [ RunTime:0.005719s ]
select * from pdf where partno='471018264152' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471018264152' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.021088s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780788 AND `partno` = '471018264152' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.007948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19564448 [ RunTime:0.010497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780726 LIMIT 5 [ RunTime:0.049641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780726 ORDER BY `minOrder` ASC [ RunTime:0.048716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780726 ORDER BY `unit` DESC [ RunTime:0.015220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780726 LIMIT 2 [ RunTime:0.025367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780726 ORDER BY `minOrder` ASC [ RunTime:0.024842s ]
select * from pdf where partno='471015264152' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.042269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471015264152' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.060493s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780726 AND `partno` = '471015264152' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.033375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17294437 [ RunTime:0.022317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780719 LIMIT 5 [ RunTime:0.058798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780719 ORDER BY `minOrder` ASC [ RunTime:0.100512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780719 ORDER BY `unit` DESC [ RunTime:0.013344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780719 LIMIT 2 [ RunTime:0.008845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780719 ORDER BY `minOrder` ASC [ RunTime:0.008138s ]
select * from pdf where partno='471005264153' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471005264153' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015588s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780719 AND `partno` = '471005264153' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553522 [ RunTime:0.008210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780769 LIMIT 5 [ RunTime:0.023788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780769 ORDER BY `minOrder` ASC [ RunTime:0.010973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780769 ORDER BY `unit` DESC [ RunTime:0.019252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780769 LIMIT 2 [ RunTime:0.013559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780769 ORDER BY `minOrder` ASC [ RunTime:0.001985s ]
select * from pdf where partno='471023262153' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '471023262153' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.011659s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780769 AND `partno` = '471023262153' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19553598 [ RunTime:0.031245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58727921 LIMIT 5 [ RunTime:0.016223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727921 ORDER BY `minOrder` ASC [ RunTime:0.007612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58727921 ORDER BY `unit` DESC [ RunTime:0.014577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58727921 LIMIT 2 [ RunTime:0.007700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727921 ORDER BY `minOrder` ASC [ RunTime:0.001571s ]
select * from pdf where partno='4710.4254' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.018724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710.4254' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.013554s ]
SELECT `id` FROM `stock` WHERE `id` <> 58727921 AND `partno` = '4710.4254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.025515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11858397 [ RunTime:0.010374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58727920 LIMIT 5 [ RunTime:0.018879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727920 ORDER BY `minOrder` ASC [ RunTime:0.009907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58727920 ORDER BY `unit` DESC [ RunTime:0.026958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58727920 LIMIT 2 [ RunTime:0.009349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727920 ORDER BY `minOrder` ASC [ RunTime:0.011581s ]
select * from pdf where partno='4710.2254' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.020789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710.2254' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.007829s ]
SELECT `id` FROM `stock` WHERE `id` <> 58727920 AND `partno` = '4710.2254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.012232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857749 [ RunTime:0.011904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58727919 LIMIT 5 [ RunTime:0.014001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727919 ORDER BY `minOrder` ASC [ RunTime:0.023325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58727919 ORDER BY `unit` DESC [ RunTime:0.025034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58727919 LIMIT 2 [ RunTime:0.025172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727919 ORDER BY `minOrder` ASC [ RunTime:0.009220s ]
select * from pdf where partno='4710.1014' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.026832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710.1014' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.017810s ]
SELECT `id` FROM `stock` WHERE `id` <> 58727919 AND `partno` = '4710.1014' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.046256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857748 [ RunTime:0.016129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58727922 LIMIT 5 [ RunTime:0.028100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727922 ORDER BY `minOrder` ASC [ RunTime:0.028580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58727922 ORDER BY `unit` DESC [ RunTime:0.039460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58727922 LIMIT 2 [ RunTime:0.016349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58727922 ORDER BY `minOrder` ASC [ RunTime:0.001903s ]
select * from pdf where partno='4710.3014' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.014042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710.3014' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.032799s ]
SELECT `id` FROM `stock` WHERE `id` <> 58727922 AND `partno` = '4710.3014' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.031625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857750 [ RunTime:0.004469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58728462 LIMIT 5 [ RunTime:0.013835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58728462 ORDER BY `minOrder` ASC [ RunTime:0.020141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58728462 ORDER BY `unit` DESC [ RunTime:0.020900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58728462 LIMIT 2 [ RunTime:0.019665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58728462 ORDER BY `minOrder` ASC [ RunTime:0.002909s ]
select * from pdf where partno='4710-5722-0011-215-1100' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.016136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4710-5722-0011-215-1100' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.045978s ]
SELECT `id` FROM `stock` WHERE `id` <> 58728462 AND `partno` = '4710-5722-0011-215-1100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.028654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11858201 [ RunTime:0.021417s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013284s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030162s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019254s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020527s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025903s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026565s ]
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 '4710%' OR `brand` LIKE '4710%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020787s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4710%' OR `brand` LIKE '4710%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019135s ]