SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400074 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400074 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878684,390821,672905,929781,542236,517054,422111,1000542,23763,533479,95314,316994,197740,946768,984606,35365,401400,950863,651235,416272,72150,517855,653389,21973,1028796,539362,235502,118939,774606,444047,935614,1031062,537796,254051,807074,369338,842744,122673,982198,63668,417846,379385,177821,836617,397886,843168,104995,842734,607682,20019,258100,770360,42957,918247,1024069,417948,850907,183550,863679,422858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]