SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521213 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521213 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916263,494670,934631,1015650,472660,908397,419458,366317,742598,290041,171930,30524,942619,116765,583359,609212,71604,302263,204552,1041172,944222,243485,365426,814685,897171,933261,551858,720797,243490,670961,110194,44384,452004,309450,292477,397634,231459,485266,735417,35079,940282,350117,367424,105881,966175,97940,803328,406134,542844,804833,247239,458310,28377,694850,975693,637503,106829,103795,242300,52478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]