SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154774 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154774 [ RunTime:0.003148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363481,801426,214689,772105,1019662,98770,770594,547055,758449,690019,473843,163890,1031408,656633,237835,314619,1033637,380069,587662,331673,923539,681310,52505,345671,1025383,515513,73994,662516,1022561,821270,247875,582545,199873,330027,1043893,463816,1039520,1015562,430135,63274,502074,762844,1048180,768990,747080,66695,119493,471562,198319,229571,277440,818957,291321,955125,343197,932311,485330,418081,665429,122296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]