SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261457 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261457 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498455,841045,801249,362118,265757,758701,484957,922717,822831,398650,71214,190832,645410,602468,711777,325175,999032,383198,921269,4642,879450,754917,789783,779644,204028,678089,830477,430059,675417,200357,407165,755924,111770,1034847,975093,265726,53434,986708,552191,178011,345126,31650,824405,1043367,791013,1005746,426566,284295,154158,289220,1048058,375657,794085,1008901,507769,45602,636739,924171,177080,309730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]