SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671983 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671983 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409878,892207,498252,717651,364395,675026,776700,455360,632176,1011332,435626,423723,437398,498795,288708,489688,526938,1040653,98533,547240,104714,504348,150541,845800,380581,144066,452149,122732,477549,24033,629352,103651,670070,5170,165257,846725,868856,596327,761114,871581,116646,610701,32767,253656,829679,20322,678386,81866,488266,689341,787626,721120,448935,121005,615286,1990,27637,303286,20909,273728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]