SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047289 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047289 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244174,749622,878285,812570,990946,1047967,629109,885839,935418,53130,426388,485557,325368,576213,40746,921463,137144,624079,401375,841576,355036,156902,574510,711711,496577,805151,521804,739388,234079,742180,89103,557433,952810,304276,214224,114002,345224,951279,137606,87818,733137,789165,941543,183914,315834,996965,21056,411199,78982,1026493,623429,603173,837143,509399,369018,368535,903033,403537,945916,901896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]