SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309010 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309010 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487269,199200,404495,808701,554025,103608,798961,568438,783432,32755,452794,556735,400110,237004,245042,525358,672084,515282,195937,198603,157474,639401,188973,311281,937310,283900,311102,253595,522083,641022,801639,144362,96954,111499,1016075,180250,260277,637250,1034216,983999,328543,927760,883217,434572,278172,229684,962380,905385,916643,737576,823848,669197,188862,712368,550359,506184,463582,9219,42971,122701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]