SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577081 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577081 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36883,337065,583675,8276,1034320,941343,682502,980596,36935,651074,927653,726585,628785,446509,191127,466412,443858,654207,441010,1034325,603013,438344,791848,496465,494164,111426,24032,1017984,136711,555958,402244,15933,710357,817754,97768,139209,680503,1039413,498699,441259,317247,793807,184621,545180,407698,532920,767027,81902,1021130,290995,425313,993469,1043278,254645,321329,145028,219020,650320,980301,4115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]