SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416031 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416031 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820679,150461,684195,438692,627815,437838,272638,978700,758303,211328,121362,649261,417747,14034,53199,267673,528375,882948,200724,82771,64804,367040,622212,252086,441025,24004,24954,800385,800387,1007603,31267,333673,210782,26561,98447,666923,282603,99559,684495,192350,710785,93406,248537,441528,624096,880987,440261,580705,425089,388768,592377,510251,674161,392456,634523,595123,367152,196192,452557,978784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]