SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68590 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68590 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60643,475423,112263,29740,151557,321098,784550,335905,501373,943153,121494,611491,193513,41302,895371,215377,723560,69156,202692,324009,55215,328310,22828,175067,947060,113523,517979,733472,662199,688548,929206,470713,65913,713460,979985,1035885,715144,53462,982485,710925,523323,653101,387639,470311,400891,1042996,445377,629891,995910,799089,434142,246477,183615,908995,240098,292622,777529,438521,530276,940413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]