SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045651 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045651 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664898,229559,1038004,859362,493697,265128,429819,731172,636699,354911,1033945,796723,39326,660803,101083,926446,760994,978548,479220,384605,294292,436241,162776,324824,986703,747044,818400,454013,196893,625373,62705,803266,1023479,345470,320473,348527,864906,952279,410765,197912,188985,1018981,36873,195138,416697,362172,349302,914102,13085,300517,1046302,600392,362905,570584,894155,678879,938011,600368,42095,608436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]