SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014461 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014461 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44791,535116,985265,936263,497442,100510,944283,399001,1043281,708954,725725,830748,717929,768424,192122,270712,298750,528182,185113,769919,401803,559180,697154,127729,506533,686564,485826,408409,563850,475381,915931,342205,624113,761224,242267,137964,18612,328013,832411,922587,282659,274067,1007663,623970,183776,419608,135990,587836,1028837,74776,485443,789053,210880,364750,749949,780871,33957,113715,537561,875732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]