SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53533 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53533 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710275,586884,1044031,732086,95107,440621,642281,458054,868451,836323,289770,249126,851182,1007275,521643,887482,105483,652229,968201,4665,727122,645903,473383,837051,282502,593886,103869,1014992,248598,860559,143436,319634,556196,1011426,1036309,776891,359619,294208,802566,13756,702789,907333,619904,210949,991072,570873,102954,180040,877071,113283,712736,684174,703290,385263,140817,706250,468471,945954,337141,183953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]