SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464612 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464612 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781094,143349,652590,954561,128892,17370,511515,650780,166816,550326,823984,866135,575835,651753,195880,853479,299274,170988,843994,764420,592464,375192,681088,126579,789211,405700,761790,892791,614873,83661,836429,754099,1010538,645850,845822,802889,893525,687593,123303,693950,116502,1031628,471250,14036,84502,1038695,257222,818562,201877,299085,484295,531496,532814,1025093,808895,587543,687094,401190,124353,477890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]