SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505080 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505080 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027864,5144,154708,858536,699581,740387,791668,254061,545564,273963,716534,506296,615429,85489,999829,678845,399785,651822,728516,844515,467584,438847,380196,251343,907059,24160,598030,677247,997500,898992,778967,943856,792507,30649,175859,670194,434439,740813,670279,490896,389793,913942,350920,100575,618089,867173,368235,586394,496942,1018006,116253,174824,346125,909474,613837,19384,992087,566298,739163,845242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]