SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549797 LIMIT 1 [ RunTime:0.001040s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549797 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810344,414844,373121,314816,225023,865018,472858,157208,305481,411155,178585,90010,337705,783920,719732,715481,915087,609370,1005878,485311,221645,551569,673088,1008414,742974,862136,755522,684522,1040937,603795,473798,609340,237295,541447,936824,27564,356952,485414,603353,273699,514770,634033,770130,1002593,26004,189136,697151,207347,643142,320185,419736,64066,349893,705543,989160,1709,984647,726945,44260,267009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]