SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520390 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520390 [ RunTime:0.001384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74273,279366,259608,128115,871988,860943,65715,90667,856441,255590,676026,592371,961340,696504,151331,816176,856272,95186,965430,97714,579710,268806,125145,231596,922225,495300,890668,688134,692149,984606,185862,40841,566500,626299,703738,537083,315177,140302,92258,705158,812868,700354,756858,873157,654013,730249,323456,373406,580099,79949,272105,640977,362017,635082,143293,831813,1023609,128466,565139,710378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]