SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201001 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201001 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181633,425565,895124,771351,229244,1035349,731637,689367,477023,583808,444321,122946,847860,648683,745625,95414,876861,65865,8668,1011676,84498,680154,125754,358728,307035,267239,570251,214076,626604,485184,400670,671021,108630,247084,463959,827151,495819,329406,84999,88355,277093,977752,455086,553847,161529,1005056,994634,768649,902090,582189,492607,863571,521062,974833,412013,398174,119913,934745,545069,642047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]