SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505001 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505001 [ RunTime:0.002881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191705,916895,5306,432816,18619,1015541,591786,599419,587344,805559,21540,533864,214533,89720,442838,942109,207070,654030,625886,187400,54448,999086,783536,250607,78857,155959,685438,472088,946743,683148,439474,923155,660727,808856,1038355,48819,537208,523163,891456,1030495,539133,369284,559547,204501,670585,376445,897511,442754,633252,858605,1015548,108368,180615,81224,345634,923536,708382,128985,230748,454273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002197s ]