SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541109 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541109 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511647,173448,648043,846984,144079,397652,27295,289508,1006541,691279,67263,909993,385087,878880,470080,570107,1008000,239240,407906,317477,286262,307486,262265,875993,936728,771482,83256,166719,1004306,975486,562702,315053,1025781,576866,737707,420978,243864,32909,135535,420566,317786,983993,742602,937929,128680,137235,749706,535494,662780,332497,3625,604388,358584,637747,565184,901554,454280,83746,108450,836547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]