SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022438 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022438 [ RunTime:0.003329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623032,1027409,580080,186399,897141,939579,216228,545483,791862,182384,607345,120308,441320,946279,442896,613718,792079,864049,243299,317200,716628,340495,464855,463758,732102,329375,158349,673239,758970,701248,851289,420363,883180,985467,259652,555048,726472,34561,464603,458905,458024,305227,235635,1044491,89156,763096,444134,707997,1006929,103140,50618,975814,854886,5736,795225,750479,546923,628965,814653,235557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001440s ]