SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118023 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118023 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124850,89841,1021592,1039857,683197,796945,318266,1042345,30857,512717,739471,13792,450399,855879,541681,193056,275248,696375,61587,680712,580101,14552,664680,520621,187358,813347,622410,41676,215015,301235,396369,693817,77315,183121,842207,514179,332786,868566,664488,436424,393877,223515,488391,358264,825286,885478,418419,208041,987906,570904,56127,498779,554536,588850,758005,925303,309937,643591,25299,835828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]