SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029017 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029017 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262154,524870,675391,810329,520516,824943,815343,119489,886373,922153,683658,597721,517407,306291,884105,209746,605948,337538,624509,76853,77643,853184,117499,29422,494942,830399,903221,302870,717907,950131,918513,3239,860652,962621,1031828,834046,691199,719392,39143,430876,851832,427428,537029,717505,122382,971933,722469,918005,90222,736720,1031525,713991,169730,370563,858509,651233,174295,922949,357165,497756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]