SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475413 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475413 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758951,506776,806178,1009126,445920,735518,838772,884185,262444,819927,604594,568417,762777,646634,405243,443759,991758,69917,232996,292146,972002,915223,284583,477707,187508,1040317,170076,585663,182590,530397,697266,805569,165686,782101,885975,421744,962763,298039,784012,355499,251111,597229,289573,549452,84931,166495,345462,68820,171465,463953,441383,660639,736517,926718,351057,360958,736842,585589,229614,262212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]