SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031008 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031008 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441465,640977,161492,238773,346788,122012,58959,928550,538676,531264,1034558,446565,172013,452307,1027558,758887,907937,268026,63285,371743,517681,296081,320643,678427,94668,965548,844899,749922,793224,551370,113591,189209,340834,137394,350450,592779,317737,742115,1021445,51382,773544,463161,607052,833830,237444,992245,194123,339628,213530,751719,950882,463915,834625,581044,275117,511608,424084,911713,261764,265162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004216s ]