SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480086 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480086 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494804,791256,1047947,8037,108399,243602,402166,280127,775116,610715,591314,102445,759446,799595,304777,932479,242002,575621,738292,641359,558401,818072,804778,623698,138963,968545,455384,383416,909750,651307,155252,285237,383641,459245,251415,837357,415089,556717,977516,460446,193851,517047,297027,31520,833937,946041,564626,792133,492840,48942,547302,391494,175354,874679,384403,695272,351283,97690,617734,26445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]