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` = 451320 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451320 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961987,969563,149802,343683,577912,145087,545274,57725,847625,913623,713075,946204,391221,942331,845168,66767,104537,731999,524395,260754,889466,807733,725342,702490,278683,647989,392768,174359,58093,286038,673847,71778,337325,542959,414542,152211,536282,368082,22892,726090,676816,383345,631176,1040863,315993,599431,778332,108573,648974,953813,39745,618502,554843,908748,756363,785071,73130,952312,565144,92459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]