SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562836 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562836 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412600,236812,607698,99731,442079,741823,201933,109081,83297,102049,600112,1011936,152685,95529,750592,414477,942102,537493,508361,340417,374837,356629,141990,613956,601383,814284,1015675,728260,254954,494278,393332,971921,265555,537722,1048023,179481,568618,103087,38778,831691,336791,813845,984901,527889,585448,871892,417708,917000,152322,252014,735998,690311,817095,401711,594431,548444,493163,591186,139203,60466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]