SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580743 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580743 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562080,977995,329844,961310,858751,509281,375135,526513,496400,384986,17715,1006535,616978,540294,836765,541352,174561,326070,774798,72267,902264,1002758,116888,288069,389466,768784,525801,801419,1019743,118685,51713,347469,956479,465945,408932,830745,881019,265947,954091,169992,1000135,735688,649608,807469,33091,863323,466519,634199,671061,670457,416888,707713,877009,174701,519630,1039738,950681,120051,474375,654627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]