SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 78180 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 78180 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54472,986729,812797,830537,881340,616044,205110,535667,1013516,314327,883348,1033348,632779,146555,4316,438942,927900,567787,508882,588697,704583,448573,292351,209306,603716,318505,855765,462157,477858,691082,699359,83615,1025333,354464,243893,1048888,207764,733183,175559,219774,421113,1028605,243212,949708,457411,855796,932619,530946,110624,311136,482162,79496,879701,653917,1019477,388953,933069,842715,769925,957293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 78180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 78180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000852s ]