SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001547s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.144' , `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=1059&search=1' [ RunTime:0.007549s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002226s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001313s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001876s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.144' ) [ RunTime:0.003948s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001141s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.025203s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001507s ]
SELECT * FROM `stock_search` WHERE `partno` = '1059' LIMIT 1 [ RunTime:0.026314s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 12:22:04' WHERE `partno` = '1059' [ RunTime:0.011128s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002304s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.163490s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.017553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350042 LIMIT 5 [ RunTime:0.035803s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350042 ORDER BY `minOrder` ASC [ RunTime:0.021793s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350042 ORDER BY `unit` DESC [ RunTime:0.027665s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350042 LIMIT 2 [ RunTime:0.045783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350042 ORDER BY `minOrder` ASC [ RunTime:0.075250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392161 LIMIT 5 [ RunTime:0.053535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392161 ORDER BY `minOrder` ASC [ RunTime:0.018245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14392161 ORDER BY `unit` DESC [ RunTime:0.096685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14392161 LIMIT 2 [ RunTime:0.032578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392161 ORDER BY `minOrder` ASC [ RunTime:0.027822s ]
select * from pdf where partno='10599-22' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.059621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044271 LIMIT 5 [ RunTime:0.025412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044271 ORDER BY `minOrder` ASC [ RunTime:0.034110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12044271 ORDER BY `unit` DESC [ RunTime:0.052545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12044271 LIMIT 2 [ RunTime:0.049430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12044271 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067918 LIMIT 5 [ RunTime:0.009196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067918 ORDER BY `minOrder` ASC [ RunTime:0.027737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067918 ORDER BY `unit` DESC [ RunTime:0.040166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067918 LIMIT 2 [ RunTime:0.016225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067918 ORDER BY `minOrder` ASC [ RunTime:0.006070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352093 LIMIT 5 [ RunTime:0.013904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352093 ORDER BY `minOrder` ASC [ RunTime:0.022755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352093 ORDER BY `unit` DESC [ RunTime:0.026579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352093 LIMIT 2 [ RunTime:0.003630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352093 ORDER BY `minOrder` ASC [ RunTime:0.010391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068537 LIMIT 5 [ RunTime:0.032097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068537 ORDER BY `minOrder` ASC [ RunTime:0.046877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068537 ORDER BY `unit` DESC [ RunTime:0.030092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068537 LIMIT 2 [ RunTime:0.022360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068537 ORDER BY `minOrder` ASC [ RunTime:0.051776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10979843 LIMIT 5 [ RunTime:0.031508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10979843 ORDER BY `minOrder` ASC [ RunTime:0.075536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10979843 ORDER BY `unit` DESC [ RunTime:0.023462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10979843 LIMIT 2 [ RunTime:0.055700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10979843 ORDER BY `minOrder` ASC [ RunTime:0.012817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11676939 LIMIT 5 [ RunTime:0.022228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11676939 ORDER BY `minOrder` ASC [ RunTime:0.028075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11676939 ORDER BY `unit` DESC [ RunTime:0.022317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11676939 LIMIT 2 [ RunTime:0.030551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11676939 ORDER BY `minOrder` ASC [ RunTime:0.014144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988502 LIMIT 5 [ RunTime:0.025932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988502 ORDER BY `minOrder` ASC [ RunTime:0.010246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988502 ORDER BY `unit` DESC [ RunTime:0.036448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988502 LIMIT 2 [ RunTime:0.023528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988502 ORDER BY `minOrder` ASC [ RunTime:0.017684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349002 LIMIT 5 [ RunTime:0.033770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349002 ORDER BY `minOrder` ASC [ RunTime:0.024470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349002 ORDER BY `unit` DESC [ RunTime:0.005405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349002 LIMIT 2 [ RunTime:0.009953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349002 ORDER BY `minOrder` ASC [ RunTime:0.010324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10979795 LIMIT 5 [ RunTime:0.005821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10979795 ORDER BY `minOrder` ASC [ RunTime:0.016876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10979795 ORDER BY `unit` DESC [ RunTime:0.037692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10979795 LIMIT 2 [ RunTime:0.050924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10979795 ORDER BY `minOrder` ASC [ RunTime:0.008349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988554 LIMIT 5 [ RunTime:0.017702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988554 ORDER BY `minOrder` ASC [ RunTime:0.021399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988554 ORDER BY `unit` DESC [ RunTime:0.042713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988554 LIMIT 2 [ RunTime:0.017020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988554 ORDER BY `minOrder` ASC [ RunTime:0.011617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880210 LIMIT 5 [ RunTime:0.059031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880210 ORDER BY `minOrder` ASC [ RunTime:0.084223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880210 ORDER BY `unit` DESC [ RunTime:0.014155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880210 LIMIT 2 [ RunTime:0.048757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880210 ORDER BY `minOrder` ASC [ RunTime:0.032763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872716 LIMIT 5 [ RunTime:0.030513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872716 ORDER BY `minOrder` ASC [ RunTime:0.036399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12872716 ORDER BY `unit` DESC [ RunTime:0.025816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12872716 LIMIT 2 [ RunTime:0.014942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872716 ORDER BY `minOrder` ASC [ RunTime:0.008724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12272644 LIMIT 5 [ RunTime:0.019885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272644 ORDER BY `minOrder` ASC [ RunTime:0.013717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12272644 ORDER BY `unit` DESC [ RunTime:0.013975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12272644 LIMIT 2 [ RunTime:0.062370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12272644 ORDER BY `minOrder` ASC [ RunTime:0.011180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11685733 LIMIT 5 [ RunTime:0.032962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685733 ORDER BY `minOrder` ASC [ RunTime:0.021123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11685733 ORDER BY `unit` DESC [ RunTime:0.022145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11685733 LIMIT 2 [ RunTime:0.061243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685733 ORDER BY `minOrder` ASC [ RunTime:0.015354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13340027 LIMIT 5 [ RunTime:0.057358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13340027 ORDER BY `minOrder` ASC [ RunTime:0.054679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13340027 ORDER BY `unit` DESC [ RunTime:0.029165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13340027 LIMIT 2 [ RunTime:0.026651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13340027 ORDER BY `minOrder` ASC [ RunTime:0.021588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392740 LIMIT 5 [ RunTime:0.019310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392740 ORDER BY `minOrder` ASC [ RunTime:0.011434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392740 ORDER BY `unit` DESC [ RunTime:0.012370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392740 LIMIT 2 [ RunTime:0.010163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392740 ORDER BY `minOrder` ASC [ RunTime:0.012577s ]
select * from pdf where partno='105990072' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349223 LIMIT 5 [ RunTime:0.017213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349223 ORDER BY `minOrder` ASC [ RunTime:0.017240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349223 ORDER BY `unit` DESC [ RunTime:0.016657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349223 LIMIT 2 [ RunTime:0.004287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349223 ORDER BY `minOrder` ASC [ RunTime:0.002020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20079176 LIMIT 5 [ RunTime:0.015015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20079176 ORDER BY `minOrder` ASC [ RunTime:0.003728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20079176 ORDER BY `unit` DESC [ RunTime:0.013447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20079176 LIMIT 2 [ RunTime:0.059019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20079176 ORDER BY `minOrder` ASC [ RunTime:0.032902s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51109595 LIMIT 5 [ RunTime:0.018897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109595 ORDER BY `minOrder` ASC [ RunTime:0.048191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51109595 ORDER BY `unit` DESC [ RunTime:0.004066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51109595 LIMIT 2 [ RunTime:0.021309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109595 ORDER BY `minOrder` ASC [ RunTime:0.013298s ]
select * from pdf where partno='105990010' and brandshort='seeed studio' limit 1 [ RunTime:0.006687s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '105990010' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.017452s ]
SELECT `id` FROM `stock` WHERE `id` <> 51109595 AND `partno` = '105990010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.033119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32247274 LIMIT 5 [ RunTime:0.031608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247274 ORDER BY `minOrder` ASC [ RunTime:0.006941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32247274 ORDER BY `unit` DESC [ RunTime:0.012266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32247274 LIMIT 2 [ RunTime:0.012108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32247274 ORDER BY `minOrder` ASC [ RunTime:0.021768s ]
select * from pdf where partno='105993' and brandshort='basler' limit 1 [ RunTime:0.076963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '105993' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.026966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32172588 LIMIT 5 [ RunTime:0.005459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32172588 ORDER BY `minOrder` ASC [ RunTime:0.015890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32172588 ORDER BY `unit` DESC [ RunTime:0.050583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32172588 LIMIT 2 [ RunTime:0.143790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32172588 ORDER BY `minOrder` ASC [ RunTime:0.039429s ]
select * from pdf where partno='105993' and brandshort='basler' limit 1 [ RunTime:0.016824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '105993' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.061119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070813 LIMIT 5 [ RunTime:0.035262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070813 ORDER BY `minOrder` ASC [ RunTime:0.062674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070813 ORDER BY `unit` DESC [ RunTime:0.045228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070813 LIMIT 2 [ RunTime:0.061139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070813 ORDER BY `minOrder` ASC [ RunTime:0.025375s ]
select * from pdf where partno='1059-8187' and brandshort='kontron' limit 1 [ RunTime:0.023351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059-8187' OR `brand` LIKE 'kontron%' ) ) LIMIT 1 [ RunTime:0.014806s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070813 AND `partno` = '1059-8187' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kontron%' ) [ RunTime:0.066142s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.145063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559635 LIMIT 5 [ RunTime:0.005592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559635 ORDER BY `minOrder` ASC [ RunTime:0.106942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559635 ORDER BY `unit` DESC [ RunTime:0.087089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559635 LIMIT 2 [ RunTime:0.054910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559635 ORDER BY `minOrder` ASC [ RunTime:0.015911s ]
select * from pdf where partno='10599CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.037001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10599CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.037753s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559635 AND `partno` = '10599CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.093443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349223 [ RunTime:0.049709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561813 LIMIT 5 [ RunTime:0.038710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561813 ORDER BY `minOrder` ASC [ RunTime:0.037648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561813 ORDER BY `unit` DESC [ RunTime:0.116930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561813 LIMIT 2 [ RunTime:0.023970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561813 ORDER BY `minOrder` ASC [ RunTime:0.017558s ]
select * from pdf where partno='10591CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.027660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10591CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.056908s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561813 AND `partno` = '10591CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067918 [ RunTime:0.091082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104295 LIMIT 5 [ RunTime:0.018320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104295 ORDER BY `minOrder` ASC [ RunTime:0.047057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104295 ORDER BY `unit` DESC [ RunTime:0.061830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104295 LIMIT 2 [ RunTime:0.046512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104295 ORDER BY `minOrder` ASC [ RunTime:0.015744s ]
select * from pdf where partno='1059' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.018941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.057014s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104295 AND `partno` = '1059' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.014729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388350 [ RunTime:0.015072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63361207 LIMIT 5 [ RunTime:0.028445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63361207 ORDER BY `minOrder` ASC [ RunTime:0.041559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63361207 ORDER BY `unit` DESC [ RunTime:0.056189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63361207 LIMIT 2 [ RunTime:0.022061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63361207 ORDER BY `minOrder` ASC [ RunTime:0.007756s ]
select * from pdf where partno='1059-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.007937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.015256s ]
SELECT `id` FROM `stock` WHERE `id` <> 63361207 AND `partno` = '1059-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.048009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63387003 LIMIT 5 [ RunTime:0.056052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387003 ORDER BY `minOrder` ASC [ RunTime:0.017581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63387003 ORDER BY `unit` DESC [ RunTime:0.031921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63387003 LIMIT 2 [ RunTime:0.044979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387003 ORDER BY `minOrder` ASC [ RunTime:0.004687s ]
select * from pdf where partno='10590A' and brandshort='Essentra Components' limit 1 [ RunTime:0.028614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10590A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.047542s ]
SELECT `id` FROM `stock` WHERE `id` <> 63387003 AND `partno` = '10590A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.022117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563322 LIMIT 5 [ RunTime:0.136673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563322 ORDER BY `minOrder` ASC [ RunTime:0.077660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563322 ORDER BY `unit` DESC [ RunTime:0.050473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563322 LIMIT 2 [ RunTime:0.084369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563322 ORDER BY `minOrder` ASC [ RunTime:0.041583s ]
select * from pdf where partno='10595CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.075663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10595CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.051071s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563322 AND `partno` = '10595CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.050914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068537 [ RunTime:0.100994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385095 LIMIT 5 [ RunTime:0.055946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385095 ORDER BY `minOrder` ASC [ RunTime:0.318315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385095 ORDER BY `unit` DESC [ RunTime:0.145354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385095 LIMIT 2 [ RunTime:0.125882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385095 ORDER BY `minOrder` ASC [ RunTime:0.170251s ]
select * from pdf where partno='1059100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.037868s ]
select foldpath,foldpath2,filename from pdf_file where id=1137946 limit 1 [ RunTime:0.041744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.079140s ]
SELECT `id` FROM `stock` WHERE `id` <> 59385095 AND `partno` = '1059100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.074383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559302 LIMIT 5 [ RunTime:0.084488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559302 ORDER BY `minOrder` ASC [ RunTime:0.131305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559302 ORDER BY `unit` DESC [ RunTime:0.050273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559302 LIMIT 2 [ RunTime:0.025126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559302 ORDER BY `minOrder` ASC [ RunTime:0.010359s ]
select * from pdf where partno='10592CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.021716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10592CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.025607s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559302 AND `partno` = '10592CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.061492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349002 [ RunTime:0.033375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61911372 LIMIT 5 [ RunTime:0.052568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911372 ORDER BY `minOrder` ASC [ RunTime:0.034363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61911372 ORDER BY `unit` DESC [ RunTime:0.018396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61911372 LIMIT 2 [ RunTime:0.016816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911372 ORDER BY `minOrder` ASC [ RunTime:0.025307s ]
select * from pdf where partno='1059563-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.043420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059563-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.028549s ]
SELECT `id` FROM `stock` WHERE `id` <> 61911372 AND `partno` = '1059563-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.027092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63362471 LIMIT 5 [ RunTime:0.031827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63362471 ORDER BY `minOrder` ASC [ RunTime:0.021297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63362471 ORDER BY `unit` DESC [ RunTime:0.026423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63362471 LIMIT 2 [ RunTime:0.019924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63362471 ORDER BY `minOrder` ASC [ RunTime:0.017900s ]
select * from pdf where partno='1059-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.017614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059-SS-20' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.020564s ]
SELECT `id` FROM `stock` WHERE `id` <> 63362471 AND `partno` = '1059-SS-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.016744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12044271 [ RunTime:0.014400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606938 LIMIT 5 [ RunTime:0.020864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606938 ORDER BY `minOrder` ASC [ RunTime:0.016151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606938 ORDER BY `unit` DESC [ RunTime:0.012637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606938 LIMIT 2 [ RunTime:0.003041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606938 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
select * from pdf where partno='1059724-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059724-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013750s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606938 AND `partno` = '1059724-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64555914 LIMIT 5 [ RunTime:0.000923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64555914 ORDER BY `minOrder` ASC [ RunTime:0.005685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64555914 ORDER BY `unit` DESC [ RunTime:0.002828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64555914 LIMIT 2 [ RunTime:0.009536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64555914 ORDER BY `minOrder` ASC [ RunTime:0.001078s ]
select * from pdf where partno='10590CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10590CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000748s ]
SELECT `id` FROM `stock` WHERE `id` <> 64555914 AND `partno` = '10590CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350042 [ RunTime:0.002854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558572 LIMIT 5 [ RunTime:0.004981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558572 ORDER BY `minOrder` ASC [ RunTime:0.008187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558572 ORDER BY `unit` DESC [ RunTime:0.003042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558572 LIMIT 2 [ RunTime:0.002397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558572 ORDER BY `minOrder` ASC [ RunTime:0.003479s ]
select * from pdf where partno='10596CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10596CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002020s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558572 AND `partno` = '10596CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606888 LIMIT 5 [ RunTime:0.011163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606888 ORDER BY `minOrder` ASC [ RunTime:0.006121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606888 ORDER BY `unit` DESC [ RunTime:0.005459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606888 LIMIT 2 [ RunTime:0.001216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606888 ORDER BY `minOrder` ASC [ RunTime:0.003195s ]
select * from pdf where partno='1059731-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059731-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001051s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606888 AND `partno` = '1059731-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20079176 [ RunTime:0.005456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385131 LIMIT 5 [ RunTime:0.009992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385131 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385131 ORDER BY `unit` DESC [ RunTime:0.012965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385131 LIMIT 2 [ RunTime:0.007790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385131 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
select * from pdf where partno='1059000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059000000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006365s ]
SELECT `id` FROM `stock` WHERE `id` <> 59385131 AND `partno` = '1059000000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61911364 LIMIT 5 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911364 ORDER BY `minOrder` ASC [ RunTime:0.014636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61911364 ORDER BY `unit` DESC [ RunTime:0.006618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61911364 LIMIT 2 [ RunTime:0.005459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911364 ORDER BY `minOrder` ASC [ RunTime:0.006558s ]
select * from pdf where partno='1059857-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059857-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023060s ]
SELECT `id` FROM `stock` WHERE `id` <> 61911364 AND `partno` = '1059857-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11680334 [ RunTime:0.008332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909912 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909912 ORDER BY `minOrder` ASC [ RunTime:0.003710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909912 ORDER BY `unit` DESC [ RunTime:0.002060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909912 LIMIT 2 [ RunTime:0.007149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909912 ORDER BY `minOrder` ASC [ RunTime:0.013323s ]
select * from pdf where partno='1059566-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059566-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002375s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909912 AND `partno` = '1059566-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.022361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872716 [ RunTime:0.002180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61016911 LIMIT 5 [ RunTime:0.002570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61016911 ORDER BY `minOrder` ASC [ RunTime:0.011079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61016911 ORDER BY `unit` DESC [ RunTime:0.022288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61016911 LIMIT 2 [ RunTime:0.005108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61016911 ORDER BY `minOrder` ASC [ RunTime:0.006216s ]
select * from pdf where partno='105925-107' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.004790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '105925-107' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.015052s ]
SELECT `id` FROM `stock` WHERE `id` <> 61016911 AND `partno` = '105925-107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.013863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10979843 [ RunTime:0.010073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61911115 LIMIT 5 [ RunTime:0.004349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911115 ORDER BY `minOrder` ASC [ RunTime:0.008509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61911115 ORDER BY `unit` DESC [ RunTime:0.008064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61911115 LIMIT 2 [ RunTime:0.009656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911115 ORDER BY `minOrder` ASC [ RunTime:0.006917s ]
select * from pdf where partno='1059691-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059691-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.006104s ]
SELECT `id` FROM `stock` WHERE `id` <> 61911115 AND `partno` = '1059691-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.007061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11676959 [ RunTime:0.002199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61016933 LIMIT 5 [ RunTime:0.005232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61016933 ORDER BY `minOrder` ASC [ RunTime:0.004438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61016933 ORDER BY `unit` DESC [ RunTime:0.006213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61016933 LIMIT 2 [ RunTime:0.003270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61016933 ORDER BY `minOrder` ASC [ RunTime:0.005057s ]
select * from pdf where partno='105925-58' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.005373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '105925-58' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.001869s ]
SELECT `id` FROM `stock` WHERE `id` <> 61016933 AND `partno` = '105925-58' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.005767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988502 [ RunTime:0.016120s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001669s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005218s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012920s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009061s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016278s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007200s ]
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 '1059%' OR `brand` LIKE '1059%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008877s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1059%' OR `brand` LIKE '1059%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021326s ]