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` = 1037108 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037108 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189163,142706,138623,1032269,427594,977794,850904,752820,883402,808177,381151,196404,733004,714504,579489,727658,958724,402776,642890,182913,587616,631996,70037,361331,283418,106019,830788,148281,91061,355135,241819,285574,749441,299132,378743,455207,627258,904400,865554,121192,455016,930131,269419,402646,23596,406035,432317,436625,647331,49933,555408,204805,158077,304354,222863,875799,321919,471205,365404,12030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]