SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47519 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47519 [ RunTime:0.004235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927126,893129,461970,529098,579434,740358,377883,387152,1048640,869917,777675,603599,1006746,169254,83072,514537,128773,216335,222835,972971,100486,631303,79754,1018592,26559,145654,474504,356124,486499,882377,299070,967110,96657,577264,747077,949556,723789,121630,68300,813546,231252,799153,657159,641499,62013,431563,551220,409666,660201,316348,685457,780413,876484,894497,788569,355846,1017383,202629,355899,671325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]