SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196420 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196420 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432296,836985,447266,958576,185995,508989,1025417,330098,213850,1043707,692050,229491,60240,279275,808680,694532,485204,449182,157323,474782,302493,139260,932125,865234,678856,94531,860518,828512,13356,191058,904866,728245,540800,596834,175618,213289,759271,583238,837472,415854,328870,740179,324256,293018,843920,994544,445261,537386,836817,924047,24031,889955,1048363,693689,905302,249342,978967,631368,215053,612813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]