SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465728 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465728 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999235,19173,78126,670247,836167,506078,733432,313880,586542,625325,36152,584486,872082,719286,14320,996068,68992,654409,556972,232844,601794,658504,353262,716908,549149,381344,530293,95972,367677,483888,124330,423627,192951,425338,156370,979050,3424,666200,759256,377064,246493,795653,157092,391776,429752,221379,861027,223999,541385,697256,187194,212888,837227,370069,199374,697018,235345,745044,234414,554911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]