SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497104 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497104 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485419,311898,38132,981168,331824,581750,265240,985899,240621,302728,513447,676833,215676,251932,369846,538506,751870,85617,865272,115506,71451,954945,739299,452622,301782,527734,142140,896465,717796,616537,460600,540579,582102,578592,328502,473545,668857,38521,370063,653022,401371,465660,1020510,814821,167406,24138,937617,226889,619236,955648,873532,546026,658307,942495,306830,28328,810819,927007,552900,607901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000915s ]