SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597751 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597751 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147088,341496,420597,46951,163398,813798,571939,150290,624001,346039,859163,697433,878466,998001,471545,501397,354383,793648,81845,1036347,400974,41982,66993,1013950,1007562,657063,310079,260057,1032878,802360,918757,624942,244642,780282,362093,569948,231404,515359,622823,510910,874002,726780,893055,995833,310408,200795,856509,20973,114226,278395,116517,526198,103678,413100,805456,447138,291910,570284,1043138,1042800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004906s ]