SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468195 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468195 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15225,1001621,428888,707706,452751,352682,57468,416795,1045688,103760,490322,942165,997813,802010,438471,844953,798637,540767,382189,1028285,616154,362687,352377,470420,804467,887571,471375,684662,183045,418379,117729,863353,860148,213772,742505,373343,622281,121261,184722,909341,468720,445391,291771,378078,82056,670109,159367,95494,79842,251213,426998,756332,378588,179910,227413,479193,237019,471135,648973,462805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]