SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84514 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84514 [ RunTime:0.002334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040588,1024800,436869,851735,294514,315840,333488,625909,902754,31634,936562,959261,708770,507349,68133,724532,269195,826461,576017,1007651,975556,16407,788065,972461,1030800,667077,143963,889484,695920,949746,386796,655894,447299,284412,933919,213140,568400,488186,22784,366118,622377,1025584,184757,541658,333092,225684,438387,941226,860255,614083,684451,603778,836964,31493,392525,492064,654677,474286,1016424,329210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]