SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022521 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022521 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508293,47027,353069,570360,348198,455594,825264,684353,458840,911810,75360,626595,115134,951299,2170,772333,48688,636128,177790,810429,754292,627141,24325,649778,684573,992117,198114,1043346,440471,981314,768265,679580,57575,328982,16363,1037027,919336,898500,310719,515435,406904,247061,575224,230997,951216,409927,974832,1013848,154181,981922,537874,604174,804004,220133,325871,813587,324848,805677,131449,789070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002538s ]