SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031049 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031049 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534861,446203,951481,412474,532491,994006,536251,982493,535433,234946,696576,225759,142587,430772,737613,954947,602217,464670,453176,610034,620374,439655,412041,912867,326448,242373,246632,224224,41615,681415,976066,543128,959923,355449,1029591,536381,850351,749961,585878,1041174,413492,740727,398998,514408,981893,37304,39720,299474,589678,981795,795939,698906,268263,498841,409017,937747,799834,69587,210976,934691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]