SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397230 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397230 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489699,763421,783682,753993,572574,102493,346413,600089,868655,1000088,152100,751343,1045281,945737,588002,879969,411933,81306,532517,511,542319,746607,888940,127603,651276,324892,374086,545708,664469,103244,2730,837678,260510,446778,66394,664168,511840,379572,500428,173519,606398,1035667,581896,701945,65843,410603,792502,718951,1011070,146573,582830,360080,452478,568667,248910,23613,153783,572543,968413,308546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]