SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484254 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484254 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517073,687434,611123,739035,432999,217010,48757,170251,611611,150551,727211,993103,864529,610407,99608,558021,852828,905557,681867,370445,44467,208582,491712,862796,556398,321618,828559,455780,994727,465758,665965,192939,706503,569701,107087,271593,810671,301205,539272,499611,128479,764837,8774,415453,709849,247331,498862,114250,706145,181284,92074,627388,409689,572246,513396,504427,235019,928354,737093,56707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]