SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527931 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527931 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048085,283826,288791,203589,22442,516027,19655,866710,171701,1041259,758178,553628,599768,83781,569224,682175,141801,760022,321907,119358,328442,608315,831507,202360,371014,84580,436379,705302,1044469,143233,265556,778408,953156,452334,524156,2871,955,681267,227706,522911,103929,622940,902086,626329,329760,673492,196147,760601,323999,127619,364107,10233,188345,896967,226431,912342,873088,655277,330650,320494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001277s ]