SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426526 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426526 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940008,545297,863011,231212,873252,224041,1910,22941,1035797,230444,213138,666713,535517,480447,279298,816989,733027,103393,625124,854101,446905,478809,473748,98725,345633,506848,997524,684674,273283,665914,770724,723051,911208,992740,181351,854824,995791,733810,715375,46690,333868,311681,641005,415287,796473,783296,421990,915322,1014975,240538,357534,863439,701424,401707,490208,885189,605213,542289,55426,544383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001600s ]