SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002957s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=UTP6A4&search=1' [ RunTime:0.012089s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001617s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009556s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002293s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.024809s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002406s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000373s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002171s ]
SELECT * FROM `stock_search` WHERE `partno` = 'UTP6A4' LIMIT 1 [ RunTime:0.051322s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 00:30:32' WHERE `partno` = 'UTP6A4' [ RunTime:0.022339s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001387s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026905s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16497036 LIMIT 5 [ RunTime:0.009642s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16497036 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16497036 ORDER BY `unit` DESC [ RunTime:0.005983s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16497036 LIMIT 2 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16497036 ORDER BY `minOrder` ASC [ RunTime:0.004991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16497035 LIMIT 5 [ RunTime:0.014739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16497035 ORDER BY `minOrder` ASC [ RunTime:0.013081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16497035 ORDER BY `unit` DESC [ RunTime:0.003417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16497035 LIMIT 2 [ RunTime:0.014423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16497035 ORDER BY `minOrder` ASC [ RunTime:0.002360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16497034 LIMIT 5 [ RunTime:0.011093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16497034 ORDER BY `minOrder` ASC [ RunTime:0.002415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16497034 ORDER BY `unit` DESC [ RunTime:0.000871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16497034 LIMIT 2 [ RunTime:0.003720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16497034 ORDER BY `minOrder` ASC [ RunTime:0.005815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496946 LIMIT 5 [ RunTime:0.004875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496946 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496946 ORDER BY `unit` DESC [ RunTime:0.006987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496946 LIMIT 2 [ RunTime:0.010343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496946 ORDER BY `minOrder` ASC [ RunTime:0.006881s ]
select * from pdf where partno='UTP6A47RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.014905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496945 LIMIT 5 [ RunTime:0.004711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496945 ORDER BY `minOrder` ASC [ RunTime:0.005960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496945 ORDER BY `unit` DESC [ RunTime:0.001052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496945 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496945 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='UTP6A47OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496879 LIMIT 5 [ RunTime:0.020713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496879 ORDER BY `minOrder` ASC [ RunTime:0.038669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496879 ORDER BY `unit` DESC [ RunTime:0.020057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496879 LIMIT 2 [ RunTime:0.012642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496879 ORDER BY `minOrder` ASC [ RunTime:0.004120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496878 LIMIT 5 [ RunTime:0.005209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496878 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496878 ORDER BY `unit` DESC [ RunTime:0.007580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496878 LIMIT 2 [ RunTime:0.005405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496878 ORDER BY `minOrder` ASC [ RunTime:0.011888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496877 LIMIT 5 [ RunTime:0.010802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496877 ORDER BY `minOrder` ASC [ RunTime:0.001245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496877 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496877 LIMIT 2 [ RunTime:0.013524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496877 ORDER BY `minOrder` ASC [ RunTime:0.005095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496876 LIMIT 5 [ RunTime:0.019129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496876 ORDER BY `minOrder` ASC [ RunTime:0.028561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496876 ORDER BY `unit` DESC [ RunTime:0.003766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496876 LIMIT 2 [ RunTime:0.034485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496876 ORDER BY `minOrder` ASC [ RunTime:0.018812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496794 LIMIT 5 [ RunTime:0.009000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496794 ORDER BY `minOrder` ASC [ RunTime:0.031771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496794 ORDER BY `unit` DESC [ RunTime:0.010725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496794 LIMIT 2 [ RunTime:0.021457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496794 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496793 LIMIT 5 [ RunTime:0.015041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496793 ORDER BY `minOrder` ASC [ RunTime:0.001657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496793 ORDER BY `unit` DESC [ RunTime:0.007508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496793 LIMIT 2 [ RunTime:0.031379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496793 ORDER BY `minOrder` ASC [ RunTime:0.010171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496792 LIMIT 5 [ RunTime:0.001654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496792 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496792 ORDER BY `unit` DESC [ RunTime:0.005652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496792 LIMIT 2 [ RunTime:0.022521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496792 ORDER BY `minOrder` ASC [ RunTime:0.024514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496791 LIMIT 5 [ RunTime:0.052617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496791 ORDER BY `minOrder` ASC [ RunTime:0.016387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496791 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496791 LIMIT 2 [ RunTime:0.004558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496791 ORDER BY `minOrder` ASC [ RunTime:0.002701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496790 LIMIT 5 [ RunTime:0.020662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496790 ORDER BY `minOrder` ASC [ RunTime:0.026189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496790 ORDER BY `unit` DESC [ RunTime:0.019565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496790 LIMIT 2 [ RunTime:0.015319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496790 ORDER BY `minOrder` ASC [ RunTime:0.007782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496725 LIMIT 5 [ RunTime:0.005963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496725 ORDER BY `minOrder` ASC [ RunTime:0.047881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496725 ORDER BY `unit` DESC [ RunTime:0.022883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496725 LIMIT 2 [ RunTime:0.027690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496725 ORDER BY `minOrder` ASC [ RunTime:0.036634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496605 LIMIT 5 [ RunTime:0.045698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496605 ORDER BY `minOrder` ASC [ RunTime:0.017233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496605 ORDER BY `unit` DESC [ RunTime:0.019597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496605 LIMIT 2 [ RunTime:0.055891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496605 ORDER BY `minOrder` ASC [ RunTime:0.004608s ]
select * from pdf where partno='UTP6A43OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.027359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496604 LIMIT 5 [ RunTime:0.057400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496604 ORDER BY `minOrder` ASC [ RunTime:0.041001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496604 ORDER BY `unit` DESC [ RunTime:0.003522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496604 LIMIT 2 [ RunTime:0.015105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496604 ORDER BY `minOrder` ASC [ RunTime:0.011142s ]
select * from pdf where partno='UTP6A43GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.031675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496603 LIMIT 5 [ RunTime:0.039305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496603 ORDER BY `minOrder` ASC [ RunTime:0.056098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496603 ORDER BY `unit` DESC [ RunTime:0.034104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496603 LIMIT 2 [ RunTime:0.010088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496603 ORDER BY `minOrder` ASC [ RunTime:0.003664s ]
select * from pdf where partno='UTP6A43GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.003142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496522 LIMIT 5 [ RunTime:0.012096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496522 ORDER BY `minOrder` ASC [ RunTime:0.041062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496522 ORDER BY `unit` DESC [ RunTime:0.015621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496522 LIMIT 2 [ RunTime:0.002298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496522 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='UTP6A42VL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496521 LIMIT 5 [ RunTime:0.014566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496521 ORDER BY `minOrder` ASC [ RunTime:0.015726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16496521 ORDER BY `unit` DESC [ RunTime:0.017679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16496521 LIMIT 2 [ RunTime:0.027308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16496521 ORDER BY `minOrder` ASC [ RunTime:0.011116s ]
select * from pdf where partno='UTP6A42RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.003535s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032047s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407971 LIMIT 5 [ RunTime:0.033723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407971 ORDER BY `minOrder` ASC [ RunTime:0.004642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407971 ORDER BY `unit` DESC [ RunTime:0.005729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407971 LIMIT 2 [ RunTime:0.017359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407971 ORDER BY `minOrder` ASC [ RunTime:0.020228s ]
select * from pdf where partno='UTP6A49VL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.016679s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A49VL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.002721s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407971 AND `partno` = 'UTP6A49VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13634924 [ RunTime:0.009685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407970 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407970 ORDER BY `minOrder` ASC [ RunTime:0.010362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407970 ORDER BY `unit` DESC [ RunTime:0.010358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407970 LIMIT 2 [ RunTime:0.021994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407970 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
select * from pdf where partno='UTP6A49RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A49RD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007043s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407970 AND `partno` = 'UTP6A49RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.022883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16497036 [ RunTime:0.010580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407969 LIMIT 5 [ RunTime:0.030761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407969 ORDER BY `minOrder` ASC [ RunTime:0.017149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407969 ORDER BY `unit` DESC [ RunTime:0.006973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407969 LIMIT 2 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407969 ORDER BY `minOrder` ASC [ RunTime:0.002734s ]
select * from pdf where partno='UTP6A49OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.011598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A49OR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.041750s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407969 AND `partno` = 'UTP6A49OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.010822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16497035 [ RunTime:0.004355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407968 LIMIT 5 [ RunTime:0.009093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407968 ORDER BY `minOrder` ASC [ RunTime:0.004336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407968 ORDER BY `unit` DESC [ RunTime:0.002489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407968 LIMIT 2 [ RunTime:0.001678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407968 ORDER BY `minOrder` ASC [ RunTime:0.010871s ]
select * from pdf where partno='UTP6A49GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A49GY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004015s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407968 AND `partno` = 'UTP6A49GY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.031432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13634923 [ RunTime:0.018856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407967 LIMIT 5 [ RunTime:0.008688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407967 ORDER BY `minOrder` ASC [ RunTime:0.029310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407967 ORDER BY `unit` DESC [ RunTime:0.006114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407967 LIMIT 2 [ RunTime:0.045339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407967 ORDER BY `minOrder` ASC [ RunTime:0.035688s ]
select * from pdf where partno='UTP6A49GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.043015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A49GR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.027195s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407967 AND `partno` = 'UTP6A49GR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.005750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16497034 [ RunTime:0.055588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407966 LIMIT 5 [ RunTime:0.065439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407966 ORDER BY `minOrder` ASC [ RunTime:0.059152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407966 ORDER BY `unit` DESC [ RunTime:0.019410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407966 LIMIT 2 [ RunTime:0.010157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407966 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
select * from pdf where partno='UTP6A49BL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.056908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A49BL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.020553s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407966 AND `partno` = 'UTP6A49BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.029765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13634922 [ RunTime:0.038814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407829 LIMIT 5 [ RunTime:0.013421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407829 ORDER BY `minOrder` ASC [ RunTime:0.025827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407829 ORDER BY `unit` DESC [ RunTime:0.023327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407829 LIMIT 2 [ RunTime:0.022978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407829 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
select * from pdf where partno='UTP6A48YL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.036429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A48YL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.017494s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407829 AND `partno` = 'UTP6A48YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.001527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505394 [ RunTime:0.005327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407828 LIMIT 5 [ RunTime:0.028755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407828 ORDER BY `minOrder` ASC [ RunTime:0.090144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407828 ORDER BY `unit` DESC [ RunTime:0.024960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407828 LIMIT 2 [ RunTime:0.025779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407828 ORDER BY `minOrder` ASC [ RunTime:0.012862s ]
select * from pdf where partno='UTP6A48RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.027388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A48RD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.019763s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407828 AND `partno` = 'UTP6A48RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.025272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505393 [ RunTime:0.010302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407827 LIMIT 5 [ RunTime:0.013097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407827 ORDER BY `minOrder` ASC [ RunTime:0.037136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407827 ORDER BY `unit` DESC [ RunTime:0.050210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407827 LIMIT 2 [ RunTime:0.059782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407827 ORDER BY `minOrder` ASC [ RunTime:0.003616s ]
select * from pdf where partno='UTP6A48OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A48OR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.012902s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407827 AND `partno` = 'UTP6A48OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.008218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505392 [ RunTime:0.016289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407826 LIMIT 5 [ RunTime:0.010794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407826 ORDER BY `minOrder` ASC [ RunTime:0.005263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407826 ORDER BY `unit` DESC [ RunTime:0.018222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407826 LIMIT 2 [ RunTime:0.023087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407826 ORDER BY `minOrder` ASC [ RunTime:0.051208s ]
select * from pdf where partno='UTP6A48GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A48GY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.010641s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407826 AND `partno` = 'UTP6A48GY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.011417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505391 [ RunTime:0.005884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407825 LIMIT 5 [ RunTime:0.015388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407825 ORDER BY `minOrder` ASC [ RunTime:0.028407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407825 ORDER BY `unit` DESC [ RunTime:0.016708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407825 LIMIT 2 [ RunTime:0.003622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407825 ORDER BY `minOrder` ASC [ RunTime:0.004900s ]
select * from pdf where partno='UTP6A48GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.012805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A48GR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.021325s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407825 AND `partno` = 'UTP6A48GR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.047420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505390 [ RunTime:0.016115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407824 LIMIT 5 [ RunTime:0.009862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407824 ORDER BY `minOrder` ASC [ RunTime:0.020645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407824 ORDER BY `unit` DESC [ RunTime:0.018522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407824 LIMIT 2 [ RunTime:0.012965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407824 ORDER BY `minOrder` ASC [ RunTime:0.008562s ]
select * from pdf where partno='UTP6A48BL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.018338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A48BL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.019811s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407824 AND `partno` = 'UTP6A48BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.059838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505389 [ RunTime:0.002855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407726 LIMIT 5 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407726 ORDER BY `minOrder` ASC [ RunTime:0.009833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407726 ORDER BY `unit` DESC [ RunTime:0.016237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407726 LIMIT 2 [ RunTime:0.004685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407726 ORDER BY `minOrder` ASC [ RunTime:0.010713s ]
select * from pdf where partno='UTP6A47YL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47YL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.022025s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407726 AND `partno` = 'UTP6A47YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.011102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505342 [ RunTime:0.001823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407725 LIMIT 5 [ RunTime:0.002138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407725 ORDER BY `minOrder` ASC [ RunTime:0.025551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407725 ORDER BY `unit` DESC [ RunTime:0.058098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407725 LIMIT 2 [ RunTime:0.002818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407725 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
select * from pdf where partno='UTP6A47VL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47VL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.020030s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407725 AND `partno` = 'UTP6A47VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.023609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505341 [ RunTime:0.002127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407724 LIMIT 5 [ RunTime:0.028304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407724 ORDER BY `minOrder` ASC [ RunTime:0.029466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407724 ORDER BY `unit` DESC [ RunTime:0.010859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407724 LIMIT 2 [ RunTime:0.009120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407724 ORDER BY `minOrder` ASC [ RunTime:0.004980s ]
select * from pdf where partno='UTP6A47RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47RD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000953s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407724 AND `partno` = 'UTP6A47RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496946 [ RunTime:0.020067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407723 LIMIT 5 [ RunTime:0.009850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407723 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407723 ORDER BY `unit` DESC [ RunTime:0.002056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407723 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407723 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='UTP6A47OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47OR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000959s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407723 AND `partno` = 'UTP6A47OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496945 [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407722 LIMIT 5 [ RunTime:0.004443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407722 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407722 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407722 LIMIT 2 [ RunTime:0.005732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407722 ORDER BY `minOrder` ASC [ RunTime:0.003759s ]
select * from pdf where partno='UTP6A47GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47GY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.002024s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407722 AND `partno` = 'UTP6A47GY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.012297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13634866 [ RunTime:0.025782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407721 LIMIT 5 [ RunTime:0.010619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407721 ORDER BY `minOrder` ASC [ RunTime:0.002534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407721 ORDER BY `unit` DESC [ RunTime:0.000771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407721 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407721 ORDER BY `minOrder` ASC [ RunTime:0.006682s ]
select * from pdf where partno='UTP6A47GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47GR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003345s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407721 AND `partno` = 'UTP6A47GR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.003646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505340 [ RunTime:0.001629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407720 LIMIT 5 [ RunTime:0.010290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407720 ORDER BY `minOrder` ASC [ RunTime:0.009633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407720 ORDER BY `unit` DESC [ RunTime:0.013266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407720 LIMIT 2 [ RunTime:0.014359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407720 ORDER BY `minOrder` ASC [ RunTime:0.003105s ]
select * from pdf where partno='UTP6A47BL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.006483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A47BL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.014867s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407720 AND `partno` = 'UTP6A47BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.008197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14505339 [ RunTime:0.012020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62407528 LIMIT 5 [ RunTime:0.005790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407528 ORDER BY `minOrder` ASC [ RunTime:0.038278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62407528 ORDER BY `unit` DESC [ RunTime:0.028562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62407528 LIMIT 2 [ RunTime:0.008877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62407528 ORDER BY `minOrder` ASC [ RunTime:0.027276s ]
select * from pdf where partno='UTP6A46YL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.010461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A46YL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.050899s ]
SELECT `id` FROM `stock` WHERE `id` <> 62407528 AND `partno` = 'UTP6A46YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.037399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16496879 [ RunTime:0.006879s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009811s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001393s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001217s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002412s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001211s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008712s ]
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 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002512s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UTP6A4%' OR `brand` LIKE 'UTP6A4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002409s ]