SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583522 LIMIT 1 [ RunTime:0.000785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583522 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429644,450461,92393,614043,976358,902540,743747,551088,846295,640693,696536,54814,600773,531588,268173,20908,100412,705487,515609,269663,443080,713138,545238,185808,249237,64787,989578,90555,675772,72419,806749,58383,451193,248099,145200,815810,865591,167154,65921,702735,810481,762190,825025,748115,686919,974134,839292,708140,850231,37079,497244,200816,776415,609901,582648,395334,997766,68916,455980,575797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002996s ]