SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298694 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298694 [ RunTime:0.005987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011673,456215,1042140,933114,643785,394552,460808,491893,950669,585058,572191,1028942,378640,967486,300004,220886,692497,1014612,1003650,658452,963603,243519,478420,1019617,620826,460944,439111,449319,434469,854660,662178,560869,295591,143880,67268,543595,542736,344813,686407,670385,422680,30355,847898,729542,451415,713795,665745,135282,896137,1044053,500349,577508,335894,552018,1020642,766653,32091,939865,374826,494040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002903s ]