SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048603 LIMIT 1 [ RunTime:0.000852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048603 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650519,84246,353541,652672,481157,175470,459052,7141,106593,927437,988834,68534,976494,114192,466503,403615,619975,71081,743959,490309,398184,625531,1043845,592212,864722,165930,882037,272463,167546,379262,505943,1046145,289275,218223,88632,300059,958082,36600,526361,691711,253499,498704,482555,134023,23642,26452,877776,455185,411774,839313,1008463,470271,313127,493461,635326,237995,385562,557047,658741,460010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]