SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333935 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333935 [ RunTime:0.003546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370724,955844,331029,561126,1038525,989080,75509,239437,821294,492412,220167,643056,994121,873060,780440,434551,333770,430191,950240,992960,779972,2550,48237,885956,330331,342829,188082,306024,982352,390074,205667,131503,73231,975006,369580,995951,28586,6548,816401,761937,14043,500727,563768,753526,568034,475392,1043655,631026,221530,273219,471208,842762,839229,106230,1011782,536785,739985,904437,897070,438483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]