SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404773 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404773 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623302,875677,925538,494089,520077,575543,851690,862007,649142,196182,986564,739915,807774,793555,307412,191154,665700,110034,329690,9342,221182,431176,472860,988556,290652,767572,245325,451598,870039,445494,705098,739069,309641,296330,79115,918984,667290,547029,856413,239553,84275,398733,708077,876594,140085,36544,841951,853529,723857,367338,159984,830902,103998,6537,1008284,40965,352943,1023363,698304,846653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]