SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525108 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525108 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754383,659507,990673,159737,527724,660111,454915,1015932,270859,145815,907882,829859,269471,65978,320890,867738,160529,467637,506471,664375,302651,650174,707044,296274,277762,397595,572417,506817,328045,105774,1039066,433192,887614,172155,677004,786547,87223,189085,878527,68811,678931,598034,132018,444254,127124,744082,20972,199780,593501,1012095,915749,202737,375410,917470,245204,72897,110902,160502,646642,409826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]