SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107078 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107078 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526609,1005891,127686,479056,552044,578712,318670,529505,211882,355186,192835,424913,956957,196358,336783,933416,777076,483350,854089,720495,114870,552064,285606,593526,925037,398688,39033,479586,994610,556836,737085,419776,202613,634392,592921,405874,363020,1005437,1048097,696930,648971,686670,198933,347394,910751,415934,870431,540427,316310,209110,314410,164137,127194,899432,267624,609975,468393,320155,44784,962299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]