SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474876 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474876 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505318,904532,683553,351157,462296,634786,1047112,322796,1013414,134249,433317,1025529,885896,135430,129239,817472,661015,510109,748537,587647,987437,463669,882759,156475,122076,374550,939406,101832,509344,477813,826811,382254,520613,84585,38257,972677,470037,986886,300249,888841,956764,95044,82477,282717,452949,83802,253074,355759,947186,1048694,922537,154841,412802,191706,813890,969955,311943,690740,824088,165879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001113s ]