SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534380 LIMIT 1 [ RunTime:0.000847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534380 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902216,24682,507120,630206,759196,136591,226221,595914,19151,143267,103271,71793,354176,722603,542834,757734,605220,600963,1015530,429022,782456,614589,780799,863225,793056,341868,140962,856413,343060,858784,940875,690429,306139,758109,296654,649009,130495,453585,452346,632746,757356,450873,412708,333897,660925,483466,329562,822486,538971,89835,798782,408968,554504,77939,505520,56947,94340,304414,860031,516977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]