SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026091 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026091 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000556,869879,87933,870092,790996,95628,484829,920912,1012741,295114,914049,687173,870149,843329,584412,250889,140185,920707,629499,75337,539336,484821,892609,925306,501715,400476,274201,550272,350135,802622,83861,7217,437404,652253,846596,432933,371486,277665,560525,189294,275175,966476,333755,124001,795738,700322,304901,432924,720799,324068,112244,150601,926251,121859,162748,579000,567148,479036,145660,476333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]