SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041942 LIMIT 1 [ RunTime:0.000605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041942 [ RunTime:0.005722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246995,483990,1040964,757492,401793,34971,581612,45648,301380,697956,750340,364693,1026164,150883,503567,387913,807308,2801,535871,932056,795616,966249,320982,637602,532867,262435,439884,841804,579465,962536,767713,582331,904444,153067,940197,385054,165290,1043119,205999,912152,307663,998480,51821,661064,863846,33328,516317,26012,352264,209115,589713,433221,473281,389432,240646,552185,518193,147236,179160,110139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]