SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001237s ]
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=PTY02E-10-6P&search=1' [ RunTime:0.004927s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001326s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000555s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001698s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.009399s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001406s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004655s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001710s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PTY02E-10-6P' LIMIT 1 [ RunTime:0.012104s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-28 17:56:03' WHERE `partno` = 'PTY02E-10-6P' [ RunTime:0.005485s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001573s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003396s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13101115 LIMIT 5 [ RunTime:0.026923s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13101115 ORDER BY `minOrder` ASC [ RunTime:0.008964s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13101115 ORDER BY `unit` DESC [ RunTime:0.015648s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13101115 LIMIT 2 [ RunTime:0.013120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13101115 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095537 LIMIT 5 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095537 ORDER BY `minOrder` ASC [ RunTime:0.001243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095537 ORDER BY `unit` DESC [ RunTime:0.001753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095537 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095537 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095536 LIMIT 5 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095536 ORDER BY `minOrder` ASC [ RunTime:0.003474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095536 ORDER BY `unit` DESC [ RunTime:0.003781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095536 LIMIT 2 [ RunTime:0.017815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095536 ORDER BY `minOrder` ASC [ RunTime:0.006809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095535 LIMIT 5 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095535 ORDER BY `minOrder` ASC [ RunTime:0.010839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095535 ORDER BY `unit` DESC [ RunTime:0.011965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095535 LIMIT 2 [ RunTime:0.016516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095535 ORDER BY `minOrder` ASC [ RunTime:0.014152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095534 LIMIT 5 [ RunTime:0.017709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095534 ORDER BY `minOrder` ASC [ RunTime:0.013672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095534 ORDER BY `unit` DESC [ RunTime:0.006194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095534 LIMIT 2 [ RunTime:0.003090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095534 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095533 LIMIT 5 [ RunTime:0.006172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095533 ORDER BY `minOrder` ASC [ RunTime:0.014253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095533 ORDER BY `unit` DESC [ RunTime:0.012186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095533 LIMIT 2 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095533 ORDER BY `minOrder` ASC [ RunTime:0.004509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095532 LIMIT 5 [ RunTime:0.023168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095532 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095532 ORDER BY `unit` DESC [ RunTime:0.010808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095532 LIMIT 2 [ RunTime:0.020822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095532 ORDER BY `minOrder` ASC [ RunTime:0.017147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095531 LIMIT 5 [ RunTime:0.023053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095531 ORDER BY `minOrder` ASC [ RunTime:0.021616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11095531 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11095531 LIMIT 2 [ RunTime:0.006182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11095531 ORDER BY `minOrder` ASC [ RunTime:0.029915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10763926 LIMIT 5 [ RunTime:0.009529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10763926 ORDER BY `minOrder` ASC [ RunTime:0.029030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10763926 ORDER BY `unit` DESC [ RunTime:0.012711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10763926 LIMIT 2 [ RunTime:0.009048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10763926 ORDER BY `minOrder` ASC [ RunTime:0.012610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10763924 LIMIT 5 [ RunTime:0.033913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10763924 ORDER BY `minOrder` ASC [ RunTime:0.015674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10763924 ORDER BY `unit` DESC [ RunTime:0.009212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10763924 LIMIT 2 [ RunTime:0.005274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10763924 ORDER BY `minOrder` ASC [ RunTime:0.014142s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005495s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61766474 LIMIT 5 [ RunTime:0.004585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766474 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61766474 ORDER BY `unit` DESC [ RunTime:0.008068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61766474 LIMIT 2 [ RunTime:0.002744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766474 ORDER BY `minOrder` ASC [ RunTime:0.009627s ]
select * from pdf where partno='PTY02E-10-6P(023)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007029s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(023)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006045s ]
SELECT `id` FROM `stock` WHERE `id` <> 61766474 AND `partno` = 'PTY02E-10-6P(023)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095536 [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61766473 LIMIT 5 [ RunTime:0.009692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766473 ORDER BY `minOrder` ASC [ RunTime:0.007781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61766473 ORDER BY `unit` DESC [ RunTime:0.001838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61766473 LIMIT 2 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766473 ORDER BY `minOrder` ASC [ RunTime:0.010190s ]
select * from pdf where partno='PTY02E-10-6P(011)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(011)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000594s ]
SELECT `id` FROM `stock` WHERE `id` <> 61766473 AND `partno` = 'PTY02E-10-6P(011)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.010171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095535 [ RunTime:0.007928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61766472 LIMIT 5 [ RunTime:0.023978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766472 ORDER BY `minOrder` ASC [ RunTime:0.003866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61766472 ORDER BY `unit` DESC [ RunTime:0.021062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61766472 LIMIT 2 [ RunTime:0.010188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766472 ORDER BY `minOrder` ASC [ RunTime:0.015356s ]
select * from pdf where partno='PTY02E-10-6P(013)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.022669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(013)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.004656s ]
SELECT `id` FROM `stock` WHERE `id` <> 61766472 AND `partno` = 'PTY02E-10-6P(013)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095534 [ RunTime:0.009004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61766471 LIMIT 5 [ RunTime:0.023099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766471 ORDER BY `minOrder` ASC [ RunTime:0.004567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61766471 ORDER BY `unit` DESC [ RunTime:0.022218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61766471 LIMIT 2 [ RunTime:0.010096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766471 ORDER BY `minOrder` ASC [ RunTime:0.004790s ]
select * from pdf where partno='PTY02E-10-6P(021)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(021)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.007918s ]
SELECT `id` FROM `stock` WHERE `id` <> 61766471 AND `partno` = 'PTY02E-10-6P(021)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095533 [ RunTime:0.004328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61766470 LIMIT 5 [ RunTime:0.002993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766470 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61766470 ORDER BY `unit` DESC [ RunTime:0.002502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61766470 LIMIT 2 [ RunTime:0.002389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766470 ORDER BY `minOrder` ASC [ RunTime:0.014194s ]
select * from pdf where partno='PTY02E-10-6P(009)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(009)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.000782s ]
SELECT `id` FROM `stock` WHERE `id` <> 61766470 AND `partno` = 'PTY02E-10-6P(009)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095532 [ RunTime:0.002742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61766469 LIMIT 5 [ RunTime:0.006474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766469 ORDER BY `minOrder` ASC [ RunTime:0.007948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61766469 ORDER BY `unit` DESC [ RunTime:0.002072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61766469 LIMIT 2 [ RunTime:0.001953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61766469 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
select * from pdf where partno='PTY02E-10-6P(001)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.016337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(001)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.006638s ]
SELECT `id` FROM `stock` WHERE `id` <> 61766469 AND `partno` = 'PTY02E-10-6P(001)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.001007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095531 [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61306722 LIMIT 5 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61306722 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61306722 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61306722 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61306722 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='PTY02E-10-6PW(072)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.000281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6PW(072)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000300s ]
SELECT `id` FROM `stock` WHERE `id` <> 61306722 AND `partno` = 'PTY02E-10-6PW(072)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10763926 [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61306719 LIMIT 5 [ RunTime:0.004697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61306719 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61306719 ORDER BY `unit` DESC [ RunTime:0.001519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61306719 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61306719 ORDER BY `minOrder` ASC [ RunTime:0.001417s ]
select * from pdf where partno='PTY02E-10-6P(072)' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.000908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(072)' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000290s ]
SELECT `id` FROM `stock` WHERE `id` <> 61306719 AND `partno` = 'PTY02E-10-6P(072)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.004031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10763924 [ RunTime:0.003683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61095130 LIMIT 5 [ RunTime:0.003484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61095130 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61095130 ORDER BY `unit` DESC [ RunTime:0.001528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61095130 LIMIT 2 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61095130 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='PTY02E-10-6P(014)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.000534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P(014)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003042s ]
SELECT `id` FROM `stock` WHERE `id` <> 61095130 AND `partno` = 'PTY02E-10-6P(014)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.015345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11095537 [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61028002 LIMIT 5 [ RunTime:0.007285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61028002 ORDER BY `minOrder` ASC [ RunTime:0.002840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61028002 ORDER BY `unit` DESC [ RunTime:0.007084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61028002 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61028002 ORDER BY `minOrder` ASC [ RunTime:0.002712s ]
select * from pdf where partno='PTY02E-10-6P' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.000422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTY02E-10-6P' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 61028002 AND `partno` = 'PTY02E-10-6P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13101115 [ RunTime:0.003696s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006209s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000434s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016229s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003603s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005357s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000843s ]
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 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000508s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PTY02E-10-6P%' OR `brand` LIKE 'PTY02E-10-6P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006999s ]