SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193415 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193415 [ RunTime:0.003536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168615,986506,476200,1003609,1032997,147457,621988,70509,343121,203535,400104,294327,1040443,281007,68370,472814,128561,274477,627638,821211,131011,411852,785353,827734,723359,299098,60252,25956,218610,155700,838011,403703,801754,1040774,616236,831925,60094,218404,838236,372887,482691,1009574,821609,56326,248522,369206,1029548,432464,145314,709426,2843,872278,496204,794014,683153,158372,85243,833204,395093,307284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001851s ]