SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 848018 LIMIT 1 [ RunTime:0.004137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 848018 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595039,887371,888994,949652,405723,467973,685122,1009120,252338,620983,445897,685818,390717,431418,464200,235859,1023836,823856,1037795,383663,720870,878456,671869,810587,507166,432165,39393,337357,862035,132630,551568,433236,813527,349925,333175,348070,662118,723400,633075,781089,570869,210591,385461,324811,455953,509831,303261,108519,75204,70316,443868,739041,580953,124918,762783,176785,321327,135423,979239,159796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 848018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 848018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004942s ]