SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593200 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593200 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406039,778922,491673,952069,132882,908999,754446,72935,184766,110409,855701,837209,585251,668987,701800,464338,394628,361699,555501,627739,477439,411848,358815,54353,982233,607501,146706,424695,834790,337008,27556,1016486,29650,83612,446622,1022056,626392,22457,845845,770448,590099,37807,480318,313305,63437,657558,164802,331704,395107,842193,382599,745468,746500,668143,335263,987421,488509,427159,340422,560367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]