SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597326 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597326 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482216,1013834,840675,1021482,995159,989894,593898,520997,689258,366747,318629,650895,155622,10973,95886,777566,358462,1004945,878443,929583,882711,233762,901114,85787,580669,200061,282480,871948,197992,254245,382883,604318,1966,646952,860498,411309,150825,483063,843410,332445,412007,132270,778458,885591,455871,873816,367093,253594,608443,790516,868144,112687,873583,414188,303010,137480,434766,893742,160458,127938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]