SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423209 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423209 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444271,514697,43298,399971,759912,836850,157351,993792,768499,770874,462520,269017,348780,607685,563029,146267,894726,516469,275900,9575,178209,370436,923870,75540,803458,826981,863623,553316,50483,355167,176546,437891,864106,244394,544603,379889,54352,902012,29528,239796,745187,641049,41506,897091,395102,633683,300483,468252,566334,765354,252130,264617,396906,95506,89023,771383,286674,289386,855160,712299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]