SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415395 LIMIT 1 [ RunTime:0.004130s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415395 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692837,600985,914110,167924,722082,126707,528359,306651,238371,445248,905185,200356,54519,79460,222048,1039893,445448,706655,91171,989962,758974,406185,140720,424975,188522,1015636,499542,8409,1008175,613227,220734,626524,316637,895692,769522,285365,534696,730227,284494,502554,836049,214888,456699,204084,21033,171579,921213,667400,328499,89897,183813,261490,306989,793528,692351,646575,103014,753471,336507,961417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000877s ]