SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511810 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511810 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554245,276984,956438,10440,874019,66470,37793,799932,737813,662420,385450,875537,987860,325549,860813,603810,422447,832307,511634,871770,152497,111912,838690,367857,975876,821489,803118,654071,13380,23634,303890,423075,519923,819078,59899,88429,862135,145718,102806,249233,415823,983252,741316,362198,125706,645645,792451,419576,54830,121138,52587,18155,395361,413322,624647,92528,698976,218014,884543,825606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]