SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46618 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46618 [ RunTime:0.003363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28544,645342,393403,879737,341161,781893,507940,706728,877048,540667,49372,238761,487728,767651,330707,975923,913744,569722,353607,1030871,588561,817862,24705,851957,895762,374163,200081,672071,499047,469853,739594,32117,312131,1034851,1024354,579740,472247,745342,632694,836260,296810,676628,859243,331579,235707,298309,743730,306968,105002,796042,149375,373274,872267,280187,593847,391604,783972,335791,729612,663217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]