SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424023 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424023 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496942,898922,344267,31430,603036,955912,925359,822207,255500,77361,872922,406364,138768,219490,935117,57409,694721,626081,1024624,220107,107166,346840,372341,533896,949139,544957,523786,883610,910485,922467,61255,402776,25246,21893,346007,404272,737694,586996,736588,799781,98844,781713,949561,206328,367,735332,781434,348409,845652,614536,976117,632995,422778,569036,377066,915369,1017990,646223,901785,314642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]