SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424823 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424823 [ RunTime:0.002576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890794,806777,628062,413313,690660,52334,196203,251100,956591,586184,508297,624790,393785,850505,54800,236081,798303,1003106,292211,246430,344372,878043,931102,696178,793907,193042,18756,10895,252764,829074,776994,444190,607545,560903,896571,722866,433300,896479,1043686,125164,869917,520172,58492,496861,295298,137397,750859,81912,989255,332949,410402,888433,176661,143754,355228,487668,572840,800971,907714,501222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]