SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406478 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406478 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839351,895976,70275,801844,918961,689126,30925,766984,604948,651727,671947,75353,915875,923915,537343,503851,204159,645007,279316,274916,345929,1029663,1009263,343861,618174,664384,853098,335494,870860,1040536,485576,848019,925130,828401,805694,300283,339194,499977,612794,106975,962048,620459,98948,196101,309611,34408,839986,1038045,248569,940990,24499,514466,970389,606378,41545,5099,536481,655041,88845,150971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]